Hi,
could you post an example of your data and the results you are looking for,
thanks

"Sarah" wrote:

Everything feeds in as #NA with that formula.

"Eduardo" wrote:

Hi,

=if(B3="PWRFUT",lookup(A3,'FUT'!A1:C20,2),lookup(A 3,'FX'!A1:C20,2))

"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