Vlookup using two different lookup values on the same worksheet

[Sean15]

Hi:

I'm trying to do VLOOKUP using two lookup values on the same worksheet (lookup value E2 and AY2 are on the same worksheet).

If lookup value in E2 and AY2 are not found in A:A, I want Excel to return error do I can correct them.

=if(VLOOKUP(E2,Sheet1!A:A,1,0, IF(VLOOKUP(Master List'!AY2,Sheet1!A:A,1,0))

Excel's error message, there is problem with formula.

Could you help please?


Regards,

Sean

 

[FDibbins]

for a start, you have not closed the 1st vlookup...
=if(VLOOKUP(E2,Sheet1!A:A,1,0), IF(VLOOKUP(Master List'!AY2,Sheet1!A:A,1,0))

2nd, try this instead...
=iferror(VLOOKUP(E2,Sheet1!A:A,1,0),VLOOKUP(Master List'!AY2,Sheet1!A:A,1,0))

 

[sweiming91]

This also can..

=IF(AND(IFERROR(IF(VLOOKUP($E:$E,$A:$A,1,0)=0, 1, VLOOKUP($E:$E,$A:$A,1,0)), 0)=0, IFERROR(IF(VLOOKUP($AY:$AY,$A:$A,1,0)=0, 1, VLOOKUP($AY:$AY,$A:$A,1,0)), 0)=0), "not found", "found")

 

[Sean15]

Thank you very much.


Sean