How Can I solve this Vlookup Formula

[dnsadservices]

=VLOOKUP($A$25,'D:\DNSDATA\AUG\List\[20-08-14.xls]Sheet1'!$D$1:$U$8000,9,0)
I want to link the Folder name and the file name by using a validation cell list.
I have try with CONCATENATE and INDIRECT functions but the result is coming #Ref

 

[mfexcel]

it seems that you have to have your targeted file(s) opened to make it work.

=VLOOKUP($A$25,'D:\DNSDATA\AUG\List\[20-08-14.xls]Sheet1'!$D$1:$U$8000,9,0)
I want to link the Folder name and the file name by using a validation cell list.
I have try with CONCATENATE and INDIRECT functions but the result is coming #Ref

 

[dnsadservices]

Is it possible to solve my vlookup funtion.... still not find any soultion...
Can any one help me ?

 

[dnsadservices]

Thank for your reply, But not find any solution...