indirect,ext

[bluepenink]

hello

i noticed with the indirect.ext formula, you can only reference to a particular cell.

is it possible to make it look off a range, and a particular row/column? i.e. like the index formula?

also, i have a index formula, im trying to enhance is so i dont have to go in 50 workbooks, so i have a path leading from my server to the folder, can i adjust that in the indirect, so it uses a cell as reference?
i.e.
original formula:
=INDEX('J:\Sales Analyst\SWAT\Archieve 2011\P1W1\[Edmonton-Winnipeg.xls]Peter Vepstas'!$A$1:$X$63,I4,I5,1)


modifying it to:
=INDEX("'J:\Sales Analyst\SWAT\Archieve 2011\"&I8&"\["&D9&".xls]"&E9&"'!"&E4&"",I4,I5,1)

where
I8 = P3W1
D9 = Edmonton-Winnipeg (branch name)
E9 = name
E4 = A1:X63

or if someone can be recommend another way..or using indirect? thxs alot

 

[GlennUK]

i noticed with the indirect.ext formula, you can only reference to a particular cell.

... I was under the impression that you could specify a range. Have you tried it?