prabhafriend
01-07-2015, 06:26 AM
Regular Formula:
=VLOOKUP(A1,'SomeDrive:\SomeFolder\SomeSubFolder\[SomeFileName.xlsx]SomeSheetName'!$A:$K,11,FALSE)
The Formula I need:
=Vlookup(A1,GetPathofFileVariable(SomeFileVariable) & SomeSheetname!$A:$K,11,FALSE)
Got No Replies Here:
http://www.mrexcel.com/forum/excel-questions/827031-how-use-path-excel-filevariable-formula.html
=VLOOKUP(A1,'SomeDrive:\SomeFolder\SomeSubFolder\[SomeFileName.xlsx]SomeSheetName'!$A:$K,11,FALSE)
The Formula I need:
=Vlookup(A1,GetPathofFileVariable(SomeFileVariable) & SomeSheetname!$A:$K,11,FALSE)
Got No Replies Here:
http://www.mrexcel.com/forum/excel-questions/827031-how-use-path-excel-filevariable-formula.html