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