VLOOKUP & IF
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
|