ExcelBanter - VLOOKUP From Multiple Data Sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP From Multiple Data Sheets (https://www.excelbanter.com/excel-worksheet-functions/193092-vlookup-multiple-data-sheets.html)

VLOOKUP From Multiple Data Sheets

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.

VLOOKUP From Multiple Data Sheets

You can have a construct like this for 3 sheets:

=IF(ISNA(vlookup1),IF(ISNA(vlookup2),IF(ISNA(vlook up3),"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

On Jun 30, 6:51*am, Jeremy wrote:
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.