Using INDIRECT in VLOOKUP to achieve a relative vlookup

[DaLaw]

Hi, I'm trying to create a VLOOKUP using INDIRECT to point the vlookup to the target file, but I'm having trouble with the syntax in the cell I'm referencing with the INDIRECT. - At least I think that's the problem!

The VLOOKUP I'm using is:

Please Login or Register  to view this content.

, and the data in cell D8 is

Please Login or Register  to view this content.

Currently I'm getting #REF! as a result of the above.

Is anybody able to help?
Many thanks,

[martesoft]

INDIRECT will not work with a closed workbook.

[DaLaw]

Thanks! I'll try to find another way then.

[NBVC]

This website has a free addin called Morefunc.xll.

http://xcell05.free.fr/english/

It has a function that works like Indirect() but allows closed workbooks.

Replace any Indirect() functions in your formula with Indirect.ext()