Vlookup using variable path name for range value
 

I have followed the examples here, but I still can't get excel to do what I
want, and I believe I'm having a syntax issue.

In my workbook, I'm trying to refer to a workbook located on a netwrok drive:
The network path and file name is:
P:\My Documents\Alpha_Numeric.xls

in cell A11 is the text: P:\My Documents\[Alpha_Numeric.xls]Sheet1

What I want to do is first a simple indirect using this string on a single
cell.

i.e. =INDIRECT("'"&A11&"'!$A:$2")

This is not working. I am getting a #REF error. I am getting some same
error trying to use indirect on a file on my desktop.

cell a3 = C:\Documents and Settings\#jlowens\Desktop\[Alpha_Numeric.xls]Sheet1
=INDIRECT("'"&A3&"'!$a:$2")

Can someone please explain what I am doing wrong.

Thank you

Vlookup using variable path name for range value
 

Indirect needs the other workbook to be open. Laurent Longre has a utility
called Morefunc that has a function called INDIREC.EXT that will work and
Harlan Grove wrote a UDF called Pull

http://www.download.com/Morefunc/300...-10423160.html

ftp://members.aol.com/hrlngrv/ (look for pull.zip)

--
Regards,

Peo Sjoblom

Portland, Oregon




"Jeff Lowenstein" wrote in
message ...
I have followed the examples here, but I still can't get excel to do what I
want, and I believe I'm having a syntax issue.

In my workbook, I'm trying to refer to a workbook located on a netwrok
drive:
The network path and file name is:
P:\My Documents\Alpha_Numeric.xls

in cell A11 is the text: P:\My Documents\[Alpha_Numeric.xls]Sheet1

What I want to do is first a simple indirect using this string on a single
cell.

i.e. =INDIRECT("'"&A11&"'!$A:$2")

This is not working. I am getting a #REF error. I am getting some same
error trying to use indirect on a file on my desktop.

cell a3 = C:\Documents and
Settings\#jlowens\Desktop\[Alpha_Numeric.xls]Sheet1
=INDIRECT("'"&A3&"'!$a:$2")

Can someone please explain what I am doing wrong.

Thank you