Another INDIRECT.EXT Question

[DM2]

Sorry guy's...It's me again...

I'm trying to use the INDIRECT.EXT function from within a MATCH function. When I enter the formula without the INDIRECT.EXT function it returns the correct value of 440. When I use the INDIRECT.EXT function I get a #REF error.

Function WithOUT
=MATCH(C1,'T:\Projects Contracts\09-022 Marathon Oil - Alba Living Quarters\05 - Design Information\[09-022-001 - Instrument Database.xls]Index'!$Q$5:$Q$521,0)

Function With
=MATCH(C1,(INDIRECT.EXT("'T:\Projects Contracts\"&A1&"\05 - Design Information\["&A2&A3&" - Instrument Database.xls]"&A4&"'!Q5:Q521")),0)

Where:
A1 = 09-022 Marathon Oil - Alba Living Quarters (Directory Name)
A2 = 09-022-00 (File name which is actually 09-022-001 - Instrument Database.xls)
A3 = 1 (File Revision Level, as part of the File Name)
A4 = INDEX (Worksheet Tab)

When I don't nest the INDIRECT.EXT function in another function, and don't use multiple cell references (Q5:Q521), the INDIRECT.EXT works.

I haven't tried using a "Named" reference in another sheet with the INDIRECT.EXT function as I'm not sure that's possible.

Any suggestions?
Signed...Looking for Direction...
Regards,
Dan

[Domenic]

Have a look here...

Hope this helps!