Hi. I have a vlookup formula.
The current formula is =VLOOKUP(IF(P1=0,5,P1),Rebate1,2,FALSE)
However I now have 2 named ranges and whatever is in cell O1 will determine which named range to lookup.
So if Cell O1 = "1" IT LOOKSUP NAMED RANGE "Rebate1" If O1 = "2" it looks up named range "Rebate2"
Can anyone help me expand the vlookup formula to add this condition?
Thanks in advance.
The current formula is =VLOOKUP(IF(P1=0,5,P1),Rebate1,2,FALSE)
However I now have 2 named ranges and whatever is in cell O1 will determine which named range to lookup.
So if Cell O1 = "1" IT LOOKSUP NAMED RANGE "Rebate1" If O1 = "2" it looks up named range "Rebate2"
Can anyone help me expand the vlookup formula to add this condition?
Thanks in advance.