Forum Discussion
New to excel: Calculator or estimator
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% |
Hi BargieGirl
your formula has one error:
you refer to $B$2:$D$11010, which covers 3 columns (B, C, D). But in the next argument, you refer to column 4, which is not possible. Instead, it should be
=VLOOKUP(K5,$B$2:$D$11010,3,FALSE)
If you still do not get a proper result, the reason might be the data format: It looks as if the values in column B are text (what you can see on the little green triangle in the left top corner of each cell).
Just make sure, that the cell K5 is uses also text format for the entry. Otherwise the vlookup tries to find a number in a range of text. This will not match, even if the values look the same.
Martin_Weiss Thank you! I managed to make it work. I had to get rid of the green corners and also to make sure my cells were text.
I am working on creating a very similar excel spreadsheet for my clinic and would love more information on how you go this to work. I am trying to have a feature where if I enter a CPT code into a cell it will put our self pay cost from another spreadsheet into the next column. Looking to create a cost estimator tool as my EMR does not support it. Let me know if you can help!
Thanks,
@DermHealth
