Forum Discussion

Copper Contributor

Jan 09, 2022

New to excel: Calculator or estimator

I am trying to create from the Medicare fee schedule which has CPT codes and a payment amount. a cost estimator. I can use the see the FS(fee schedule) that sheet is on or a new sheet. I nee...

excel

Martin_Weiss

Bronze Contributor

Jan 10, 2022

Hi BargieGirl

the function that you can use for this is VLOOKUP.

For your example, if the CPT schedule is in Sheet2 and you type the CPT code in cell B1 on Sheet1, you can use this formula

=VLOOKUP(B1;Sheet2!$B$2:$D$7;3;FALSE)

Just note that you have to adjust the lookup-range according to the real number of lines in your table. So instead of $B$2:$D$7 it could be $B$2:$D$100, if you have 100 lines.

BargieGirl

Copper Contributor

Jan 10, 2022

Martin_Weiss here is the formula I used. =VLOOKUP(K5,$B$2:$D$11010,4,FALSE) I tried to do it on the same sheet. So basically, what I am trying to do is to be able type a cpt code in one cell and then the cell next to it the pmt comes up from a formula or Vlookup. I wish I could send you the spreadsheet and you see if you can make something.

Still doesn't work.

CPT	PMT

60500	#N/A
78800	#N/A
76536	#N/A
		TOTAL
		X20%