Using an array formula with multiple worksheets in one workbook

G

Guest

I am using the formula : =INDEX('D:\GLOBAL X RAY\[customer price
level4.xls]Sheet1'!$A2:$C2,3) and this works. However, the worksheet -
customer price level4.xls has 16 worksheets in it. I need it to search every
worksheet, not just sheet1 and pull the information. The formula works the
way it is but it only pulls information from sheet 1. How can I get it to
check all sheets - sheet1-sheet 16?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index & multiple sheets in one workbook 6
Formula needs to include several worksheet tabs in one workbook 12
Index function - problem copying to other cells 5
One more try!! 7
Cell values to an array, then array transpose to another workbook 8
Using the INDIRECT function across multiple worksheets 1
Excel Wildcard in Excel array formula 0
formula problem in grouped worksheets 1

Top