Need UDF of Indirect.ext

[prasadavasare]

Need UDF of Indirect.ext to get the second argument of VLOOKUP and MATCH function. e.g. Below:

B2:=VLOOKUP($A2,indirect.ext($D2),MATCH(B$1,indict.ext($E2),0),0)

D2:="'C:\Mypath\[abc.xlsx]Master'!$A:$G" (Text Path)
E2:="'C:\Mypath\[abc.xlsx]Master'!$2:$2" (Text Path)


Please help

[:) Sixthsense :)]

Here is the alternative UDF to Indirect.Ext()

http://numbermonger.com/2012/02/11/e...sed-workbooks/

[prasadavasare]

Thank you SixthSense, but this function is very slow. There are 100's of files and path name I am using; almost 100's of rows down the line with different path names. This works but doesn't suites in the situation. Additionally just an FYI, the 100's of files are protected with the SAME password