| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup across multiple worksheets
I want to create a summary sheet that will lookup a particular cells value on
multiple sheets (averaging 58 sheets) in a workbook (e.g. $J$19) based upon a cell next to it ($I$19) that will match the criteria on the summary sheet (e.g. w1, w2, w3). I have tried VLOOKAllSheets but when there are other similar workbooks open, it doesn't work right. Anyone? I appreciate your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
| How can I do a lookup to a specific cell on multiple worksheets? | Excel Worksheet Functions | |||
| How to sum values in multiple worksheets | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
