I am trying to write a formula that will first look at the value in C3 which
is identified by either 1 or 99. Then depending on either of these two
numbers, use a specific vlookup to a certain table. The best way I can
explain is to

If cell c3="1", then vlookup(a3,named range, 7,0)*B3 or if cell c3="99" then
vlookup(a3,named range,7,0)*b3

A3 B3 C3 D3
CPT Multiplier Locality 01 or 99 Allowable
99201 120%

Susan