Using an array formula with multiple worksheets in one workbook

K

klafert

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

Top