Using an array formula with multiple worksheets in one workbook

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top