In the following formula I would like the [33320I.xls] portion to be linked to a cell in my spreadsheet, so that when the cell changes, the formula changes. Does anyone have a suggestion?? thx
=VLOOKUP($B5,'D:\Extracts\P03\[33320I.xls]Sheet1'!$A$3:$U$2000,C$3,FALSE)-VLOOKUP($B5,'D:\Extracts\P04\[33320I.xls]Sheet1'!$A$3:$U$2000,C$3,FALSE)
=VLOOKUP($B5,'D:\Extracts\P03\[33320I.xls]Sheet1'!$A$3:$U$2000,C$3,FALSE)-VLOOKUP($B5,'D:\Extracts\P04\[33320I.xls]Sheet1'!$A$3:$U$2000,C$3,FALSE)