| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup from multiple sheets
i have data in 10 different sheets (Sheet 2 to Sheet11)with identical columns.
i need to use the vlookup function in Sheet1 taking the range from column E to H from each sheet. Is there any tool whereby i can make te vookup function once for all sheets and need not to use it for 10 times. regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in multiple sheets | Excel Worksheet Functions | |||
| Vlookup with Multiple criteria and multiple sheets | Excel Worksheet Functions | |||
| Using VLOOKUP in multiple sheets using | Excel Discussion (Misc queries) | |||
| VLOOKUP across multiple sheets | Excel Discussion (Misc queries) | |||
| Vlookup over multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
