Lookup help!

[jrasco1]

I am trying to form a calculation sheet and want to make it more simplistic so that if I enter the procedure code in cell C7 and the patient's insurance in cell E3 then it will fill in the facility fee and the insurance allowed amount (both located in sheet 3) in two separate fields, cells G7 and I7.

TIA!

Jessica

 

[Roderick_E]

Not enough information, but perhaps look at INDEX and MATCH