Name holding path of another workbook

[Hall]

I want to use vlookup to get a value in another workbook. But I don't want
to hardcode the path and name of that other workbook. The path and file
name should be in a separate cell and my vlookup uses that value instead.

Something like vlookup(a1,+MYNAME!a1:b10, 2), where MYNAME is the name of a
cell that has the path and filename.

How do you do this?

 

[Barb Reinhardt]

I've done this using the indirect.ext add in from here

http://xcell05.free.fr/english/index.html#Morefunc_Functions

as I recall, an example is

=vlookup(A1,indirect.ext(B1),2,false)

where
B1 = 'Z:\folder\[workbook.xls]worksheet'!a$1:b$10

Good luck!

Barb Reinhardt