Hi Jacob - that formula pulls in the date for anything that is PWRFUT, but if
B3 does not equal that, then its not looking up on the FX sheet. Everything
that isnt PWRFUT is feeding in as N/A

"Jacob Skaria" wrote:

Try

=IF(B3="PWRFUT",VLOOKUP(A3,FUT!A1:C20,2,0),VLOOKUP (A3,FX!A1:C20,2,0))

--
Jacob (MVP - Excel)


"Sarah" wrote:

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