I am using the following formula to pull data out of a External Spreadsheet, and works perfectly if I have the CH EXTRUSION SHIFT REPORT.xls file open, but as I am using Indirect function this will not work if the workbook is closed. Can I use the Index function or something else to make this...