Hi All,

I am looking to use an if statement with 2 separate vlookups. Is this
possible? Basically what I want to do is if B3=PWRFUT then
lookup(A3,'FUT'!A1:C20,2)
However, if B3 does not equal PWRFUT then lookup(A3,'FX'!A1:C20,2)

Please help - thanks