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

Another way to write that formula:

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

--
Biff
Microsoft Excel MVP


"Sarah" wrote in message
...
Actually Jacob I adjusted it and it works now. Thanks so much for your
help.

"Sarah" wrote:

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