VLOOKUP TAB to TAB in excel 2003

[sburkhar]

I need a VLOOKUP formula that will look for a price on 5 different tabs in sequence. So, if it doesn't find the price on tab 1 it will look on tab 2, then tab 3 and so on.
It also needs to be an ISERROR formula so that it will return nothing if it finds nothing.
Can you help me write that?

 

[Gerald Higgins]

This will do it across 2 worksheets, maybe you can expand it yourself for 5.

=IF(ISERROR(VLOOKUP(A1,Sheet2!A1:B5,2,FALSE)),
IF(ISERROR(VLOOKUP(A1,Sheet3!A1:B5,2,FALSE)),"",
VLOOKUP(A1,Sheet3!A1:B5,2,FALSE)),VLOOKUP(A1,Sheet2!A1:B5,2,FALSE))

BUT, a better solution might be to combine the data from all 5 tabs onto a single tab.

 

[VoG]

Or try this http://www.ozgrid.com/VBA/VlookupAllSheets.htm