If OR formula
in [Functions]
|
Prev: View Message when Mouse Hovers over Cell. (Not the Comments Fe
Next: Sumproduct formula help (possible Index????)
From: Susan on 31 May 2010 20:53 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
From: T. Valko on 31 May 2010 21:51
>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" <Susan(a)discussions.microsoft.com> wrote in message news:61AB2154-2DAA-428D-A2FF-A93B60078866(a)microsoft.com... >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 > |