| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index & multiple sheets in one workbook
Check your other post, too.
klafert wrote: I am using a formula and it works, but only for sheet 1. The source workbook has 16 worksheets. I need it to search all 16 worksheet to find a match. I need to modify my formula so that will search the whole workbook. FORMULA: =INDEX('D:\GLOBAL X RAY\[customer price level4.xls]Sheet1'!$A6:$C6,3) -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| Working with multiple sheets in a workbook | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Use the same name on multiple sheets in same workbook | Excel Discussion (Misc queries) | |||
| There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
