+ Reply to Thread
Results 1 to 3 of 3

include multiplication formula to VLOOKUP

  1. #1
    Registered User
    Join Date
    05-21-2008
    Posts
    6

    include multiplication formula to VLOOKUP

    Howdy again guys. I've been working on a simpler version of a spreadsheet I posted before and I need to add one more function to it. I'm using this VLOOKUP formula
    =IF(ISBLANK(C3),"",IF(ISERROR(VLOOKUP(C3,'Procedure Codes'!A:B,2,FALSE)),"",VLOOKUP(C3,'Procedure Codes'!A:B,2,FALSE)))

    However, I'd like to add a multiplication function to the of this formula and ask that whatever value is specificied by this formula is multiplied to the value that is typed into column D. How would I do that?

    I'd post the spreadsheet, but it's too large. Hope someone can help.

  2. #2
    Registered User
    Join Date
    05-21-2008
    Posts
    6
    Ok, I managed to upload the spreadsheet. Column E is where I am using the VLOOKUP formula. Colmn D is what I need to be multiplied into whatever value column E spits out.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-21-2008
    Posts
    6
    I must have done a really lousy job of explaining what I'm trying to do because no one seems to respond to this thread.

    Ok, the template I'm creating is for our urgent care department at work. I'm trying to tabulate all our medical codes and associate them to the dollar figure that they represent. Our coding department uses numeric and apha numeric codes that correspond with these monetary values so I had to use the VLOOKUP function to match each of these numeric and alpah numeric codes to their specific monetary value. However, some of the medical codes associate to charges that are dependent on the quantity given. I added an additional column in my spreadsheet to account for the quantity number, but I am having a hard time figure out how to get it to multiply to the appropriate column. I would appreciate if if someone else could take a look at this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1