VLOOKUP From Multiple Data Sheets

J

Jeremy

Hi.

I would like to use a VLOOKUP to find a value that could be in more than one
Sheet.

I can only enter the formula to show where one sheet is, not any others.

Please Help if you know what I am on about.

Thank You.
 
P

Pete_UK

You can have a construct like this for 3 sheets:

=IF(ISNA(vlookup1),IF(ISNA(vlookup2),IF(ISNA(vlookup3),"not
found",vlookup3),vlookup2),vlookup1)

where vlookup1 is for the first sheet, vlookup2 is for the second
sheet and vlookup3 is for the third sheet.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
VLOOKUP & Data Validation 0
Multiple VLOOKUP lookup values 1
Using a vlookup to search multiple criteria for one result? 7
INDEX_MATCH or VLOOKUP with multiple criteria? 4
trouble with (complicated) vlookup searching another workbook 2
Dragging a formula down isn't working - where am I going wrong? 1
Source information from different sheets with vlookup 0

Top