| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to lookup in numerous different sheets
Hi,
I am trying to lookup the value of one column in one worksheet in another workbook that has about 20 sheets. I know how to do a lookup seperately in each sheet but is there not a way that I can just do the one lookup from the one sheet which will search the whole workbook (looking into each of the 20 sheets) and return what i am looking for. Essentially i just need to know if the people on this one column are presesnt in any of the 20 sheets in another workbook. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP across Multiple Sheets | Excel Worksheet Functions | |||
| V-Lookup from multiple sheets | Excel Discussion (Misc queries) | |||
| Lookup through multiple sheets | Excel Worksheet Functions | |||
| Lookup different sheets and get the value from the sheet specified | Excel Worksheet Functions | |||
| Lookup from a range on separate sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
