| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with Multiple criteria and multiple sheets | Excel Worksheet Functions | |||
| Using VLOOKUP in multiple sheets using | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| VLOOKUP across multiple sheets | Excel Discussion (Misc queries) | |||
| VLOOKUP on multiple sheets | Excel Discussion (Misc queries) | |||
Linear Mode
