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)