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
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