Excel Vlookup Funtions

[dnsadservices]

Main formula =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 from a validation cell list.
I have try with CONCATENATE and INDIRECT functions but the result is coming #Ref
Please tell me how to do that.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-questions/801837-how-can-i-solve-vlookup-formula.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).