Excel help 2003

[kwat1]

Hi,

I have a spreadsheet with one worksheet that displays CPT codes (e.g 99212) per facility as well as the volume per CPT code use (4, 7, 10, etc). And another worksheet that displays all CPT codes and the medicare cost per code. I need to create a formula to where excel will know to grab the CPT code and multiply the volume and cost in each cell. I am certain that a vlookup is part of my formula but cant figure out what else needs to be put in it. Also obviously each code or use of code will change on a monthly basis since all codes will not be used in a given month.

Thank you in advance!!

 

[FKoenig]

Assuming:

Sheet1 Columns A =CPT, B =Volume
Sheet 2 Columns A = CPT, B = Cost per Code

Then Sheet 1 C1=B1*VLOOKUP(A1,Sheet2!$A$1:$B$##,2,0)
where ## = the number of rows on Sheet 2.

 

[kwat1]

Thank you that is much appreciated, I will try this when I return to work. from the way it looks it does seem correct!

 

[kwat1]

Hello,

I tried using the formula you provided and the result showed #VALUE, do you have any possible solutions on why this may have occured?

Thanks

 

[kwat1]

Hello again

I actually have figured out the issue, but I wanted to thank you again for all of your help.