Vlookup & indirect.ext

[efernandes67]

Hi,

I just installed 'morefunc' to work with 'INDIRECT.EXT' to get some data from several closed workbooks. I am trying to use VLOOKUP and INDIRECT.EXT together but i can't make it work.

Cell B1: =IFERROR(VLOOKUP("Bob";INDIRECT.EXT(A1);9;0);"")
Cell A1: ="'D:\2011\[Mai2011.xls]sheet1'!$J$1:$U$65536"

PS: It works fine with the lookup workbook opened! (My PC as Windows XP Professional with Excel 2007)

Any idea what I have to do to make it work?

Regards,
Elio Fernandes

[martindwilson]

http://www.dailydoseofexcel.com/arch...sed-workbooks/
read this and it tells you why you can't