I want to enter a number and have it look for the price next to that number and....

I work in med billing. We have contract rate with our providers. And i have an excel spread of the fee schedule. On the fee schedule there are 5 columns.
sniip 001.jpg
one for the year, CPT code, modifier, Rate, desription.

Simple enough but some of these spreadsheet have as many as 10000 lines.

is there a function or formula or template someone might be able to help me with so i can...

enter cpt in column A, enter units in column B, from it number in column A - Column C will find the corresponding number on a another sheet in the book look at the rate two columns over.

So if enter "88305" in column A the formula will look at the other sheet and fill column C with the matching fee to 88305?

I apologize if my terms aren't correct but I still have a lot left to learn about excel.

I think you should just be able to do this with an Index Match or a Vlookup. Would need to know specifics to write for you however.

Can you explain what specifics would you need? Again pretty new to excel aside from simple math formulas

If this helps...

The graphic above is the whole spread sheet only its 1500 lines long.

lets call it "sheetZero" in the work book this is locked and will only be the reference

There would be a "ENTRY Sheet 001" would appear blank.
I would enter HCPCS number in box A4, box C4 would populate with the corresponding RATE of the matching HCPCS# on "SheetZero"
down the length on the sheet as needed

I hope that make it clearer. Please tell me if it doesn't.

Could you upload a sample sheet.

It did seem to work. I copied it in a adjusted the sheet name to reflect but it just says

"#N/A"

if there are 1532 line on the original schedule would that effect the code?

I got it to work kind of. I realized there were to extra column that were hidden so I adjusted it a deleted those.
But what it appears to be doing is looking the the exact location and displaying that rate. that corresponds to
that box I am enter geographically if that makes sense.

I would like to it be able to display whatever numberI punch in. so if I punch 3 random HCPCS codes it will display
their price not just the ones that corresponds geographically. But I need it to display the corresponding rate no
matter which HCPCS number I punch in column A.

Right now no matter where i put the codes this is displayed. I played with the code a bit to try to manipulate it a
bit as i said earlier my excel knowledge is amateur at best


Again you help is much appreciated and I finally figured out how to attach the file to the post if that helps

also if someone figures the fix. I respectfully request please just post the formula as I can not download files from websites deemed unsecured by our IT Overlords.

This is weird. Some will some won't. I type some in I get the number, I type others it get "#N/A", I copy and paste number the populate right i type the exact same number under I get "#N/A"

It to like codes with letters and be more picky about codes that are all number. It is possible for an excel formula to be a tempermental jerk?

Attachment 645753