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.