Big INDIRECT Linking Issue

[shmik]

I'm trying to set up an indirect formula that will link to a file/cel
giving a reference as such:

'S:\Portfolio Analysis\Exposure Reports\JBW\[Exposure Reports JBW Fund
February 2004 JBS.xls]AG Power Ops Exposure'!IB15

(note, that this links through correctly if I put a =+ in front of it)

But when I put a formula like this:

"'"&VLOOKUP($G$4,'Contro
Panel'!$B$6:$K$15,3,FALSE)&"["&VLOOKUP($G$4,'Contro
Panel'!$B$6:$K$15,10,FALSE)&"]"&$C$4&"'!"&D$1&$A8

That renders (as I want it to):

'S:\Portfolio Analysis\Exposure Reports\JBW\[Exposure Reports JBW Fund
February 2004 JBS.xls]AG Power Ops Exposure'!IB15

Into an INDIRECT formula, I get a #REF. Any Ideas

 

[Frank Kabel]

Hi
INDIRECT only works with open workbooks. I assume that your other
workbook is NOT open.

Alternatives:
If the other workbook is closed try the following: have a look at the
Add-In MOREFUNC.XLL
(http://longre.free.fr/english)

use the function INDIRECT.EXT.e.g. (if cell A1 stores the reference)
use:

=INDIRECT.EXT(A1)

you may also have a look at the following thread (describing further
alternatives for accessing closed workbooks): http://tinyurl.com/2c62u

 

[shmik]

thank you for the help