INDIRECT.EXT function can't get over then 400 rows

[vmontal]

It seems that INDIRECT.EXT function (when the sheet is closed) can't get over then 400 rows; what can I do to solve this problem?

 

[Andrew Poulsom]

Nope, sorry, INDIRECT.EXT won't return an array from a closed workbook. This works if it's open:

=VLOOKUP(A1,INDIRECT.EXT("'"&DB_TassiSoglia_rateale&"MYFOLDER'!A1:D100"),4)

 

[vmontal]

Bad new!

Something else to solve the problem: How to get an array/matrix from a closed workbook in order to use it inside a VLOOKUP (or similar) formula

 

[Andrew Poulsom]

Some ideas here:

Daily Dose of Excel » Blog Archive » INDIRECT and closed workbooks

 

[vmontal]

Thanks a lot!