Two VLookups in one arguement

[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.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

Thanks Dave! The formula is working now. I appreciate your help.