If OR formula

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

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
Click to expand...

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
 
Back
Top