INDIRECT.EXT with VLOOKUP

Hi
I have read several threads in the hope they could help me resolve this issue as I have been trying several ways to reference data using the INDIRECT function and think I may be getting close.

I have the formula

=VLOOKUP("ladies",INDIRECT.EXT("'G:\Model\[Travel Retail "&D2&" 13 Work file.xlsx]Non-Liq Model'!$B$1:$I$4"),2,0)

Where D2 is a month (text) eg January

The result is #REF if I have the file closed but comes up with a value if I have it open. I was hoping the INDIRECT.EXT would get around this but does not seem to be working as intended in this formula.

Any ideas?

Thanks

Yes it is showing in my formula tab and i have used INDIRECT.EXT in other formula recently and it has worked.
That is the confusing thing about this.