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

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

So you have 2 different lookup tables?

Assuming that C3 can only be either 1 or 99 and nothing else.

Try this...

=VLOOKUP(A3,IF(C3=1,named_range1,named_range2),7,0 )*B3

--
Biff
Microsoft Excel MVP


"Susan" wrote in message
...
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