Two VLookups in one arguement
 

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(A 1,B!A1:B!B4,2,False),0))

Any help would be greatly appreciated.

Thanks. ME.

Two VLookups in one arguement
 

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Matt" wrote:

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(A 1,B!A1:B!B4,2,False),0))

Any help would be greatly appreciated.

Thanks. ME.

Two VLookups in one arguement
 

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.

"Dave F" wrote:

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Matt" wrote:

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(A 1,B!A1:B!B4,2,False),0))

Any help would be greatly appreciated.

Thanks. ME.

Two VLookups in one arguement
 

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

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Matt" wrote:

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.

"Dave F" wrote:

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Matt" wrote:

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(A 1,B!A1:B!B4,2,False),0))

Any help would be greatly appreciated.

Thanks. ME.

Two VLookups in one arguement
 

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

"Dave F" wrote:

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

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Matt" wrote:

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.

"Dave F" wrote:

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Matt" wrote:

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(A 1,B!A1:B!B4,2,False),0))

Any help would be greatly appreciated.

Thanks. ME.