VLOOKUP Across Multiple Tabs

[izabela92]

Hello,

I am trying to write a VLOOKUP formula that will work across different tabs. For example, if it does not find a specific number in columns A and B of Sheet1, it would search columns A and B in Sheet2, but it should only go to Sheet2 to if there is not match in Sheet1.

I hope that someone can help me out with this.

Thank you!!

 

[Johnny Thunder]

Put an example of your current formula from the first sheet then I can modify.

 

[izabela92]

Put an example of your current formula from the first sheet then I can modify.

Thank you!

=VLOOKUP(A2,Sheet2!A:C,2,0)

This is it now, I need it to look in Sheet3 if it does not find a match in Sheet2

 

[Aladin Akyurek]

If the VLOOKUP must return a number...

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},

VLOOKUP(A2,Sheet3!A:C,2,0),VLOOKUP(A2,Sheet2!A:C,2,0)))

If the VLOOKUP must return text...

=LOOKUP(REPT("z",255),CHOOSE({1,2},VLOOKUP(A2,Sheet3!A:C,2,0),VLOOKUP(A2,Sheet2!A:C,2,0)))

Another option is:

=IFERROR(VLOOKUP(A2,Sheet2!A:C,2,0),VLOOKUP(A2,Sheet3!A:C,2,0))​

<strike></strike><strike></strike>