Remove the preceding quotes and apostrophe from the cell and try

IF(ISNA(VLOOKUP($D5,INDIRECT.EXT("'"&$E$2),E$1,FAL SE)),"",VLOOKUP($D5,INDIRECT.EXT("'"&$E$2),E$1,FAL SE))


that worked on my network at work. If it doesn't then it might be a company
policy thing
since I tried with 2 closed workbooks, one that was on my C drive and one
that was on a network drive and they both worked as long as I removed the
apostrophe and the leading quote and appended them to the formula itself
instead



--


Regards,


Peo Sjoblom








"Robert_L_Ross" wrote in message
...
Maybe someone can tell me then why this doesn't work:

Cell E2 = 2
Cell F2 = 3
Cell G2 = 4 etc. through L2 = 9
Cell E3 =
''G:\GS_Secure\REPORTS\Monthly\PRODSVC\CURRENT\[PS-01_OCT.xls]Sheet1'!$C$2:$L$171
(those are two single quotes at the beginning)

Cell E5 =
=IF(ISNA(VLOOKUP($D5,INDIRECT.EXT($E$2),E$1,FALSE) ),"",VLOOKUP($D5,INDIRECT.EXT($E$2),E$1,FALSE))

When the PS-01_OCT.xls workbook is open, everything is fine, when I close
it, all cells turn to #REF!

Therefore, INDRECT.EXT does not work on closed books. The "pull" function
you mentioned also does the same (already tried that before trying
INDIRECT.EXE).

Ideas?


"Peo Sjoblom" wrote:

Worked for me when I tested it, so did Harlan Grove's Pull function

ftp://members.aol.com/hrlngrv/pull.zip


--


Regards,


Peo Sjoblom


"Robert_L_Ross" wrote in message
...
Sorry, but INDIRECT.EXT does not work. I installed the morefunc file
and
it
has the same limitation - it only returns the correct value when the
source
workbook is open. If you close it, it returns 0.

"Peo Sjoblom" wrote:

You can download an add-in called Morefunc it has a function called
INDIRECT.EXT
that will work if the source book is closed

http://xcell05.free.fr/morefunc/english/index.htm


there is no built in function that can take a string referring to
another
workbook that is not open and make it into a valid formula




--


Regards,


Peo Sjoblom


"ismae" wrote in message
...
Hi everyone!
I'm trying to make references from one book to another by using the
INDIRECT
function, but I found out it doesn't work when the source book is
not
open.
Making the same reference without the INDIRECT function works ok.
The purpose of my application is to sum data from several books into
one
summary book, but the names and quantity of books can vary
dynamically,
so
I
can't include them in my formulas.
Can anyone help me with this?