VLOOKUP From Multiple Data Sheets

  • Thread starter Thread starter Jeremy
  • Start date Start date
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.
 
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
 
Back
Top