Two VLookups in one arguement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is what I want the formula to do:
If the first VLookup arguement does not return any results, have another
VLookup formula look in another sheet. This is a simple example of the
formula:

=IF(ISNA(VLOOKUP(A1,A!$A$1:A!B3,2,FALSE),Vlookup(A1,B!A1:B!B4,2,False),0))

Any help would be greatly appreciated.

Thanks. ME.
 
So what's the question? You provide the formula below. Is it not working?
If not, give detail about what happens when you try to run it.

Dave
 
I am getting a invalid syntax error. Do you see any errors in the formula?
I have never used a formula like this so wasn't sure I have phrased correctly.
 
See if this fixes it:
=IF(ISNA(VLOOKUP(A1,A!$A$1:A!B3,2,FALSE)),Vlookup(A1,B!A1:B!B4,2,False),0)

Basically, you want a formula with the following syntax:
=IF(ISNA(VLOOKUP(...)),VLOOKUP(...),0)

You didn't put a closing parenthesis around the ISNA function, and you had
an extra parenthesis at the end of your formula.

Dave
 
Back
Top