Formula Link Help

[Aaron]

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)

 

[Aladin Akyurek]

...Anyway, is INDIRECT.EXT part of an Addin on Excel97?? Unfortunately I will have to use this formula, because the workbooks have the same name, and therefore, I cannot have them open at the same time.

INDIRECT.EXT is part of themorefunc.xlladd-in that perfectly fits your worry: "I cannot have them open at the same time".

Did you try what I suggested in my last reply?