prabha_friend
Board Regular
- Joined
- Jun 28, 2011
- Messages
- 95
Regular Formula:
=VLOOKUP(A1,'SomeDrive:\SomeFolder\SomeSubFolder\[SomeFileName.xlsx]SomeSheetName'!$A:$K,11,FALSE)
The Formula I need:
Like =Vlookup(A1,GetPathofFileVariable(SomeFileVariable) & SomeSheetname!$A:$K,11,FALSE)
=VLOOKUP(A1,'SomeDrive:\SomeFolder\SomeSubFolder\[SomeFileName.xlsx]SomeSheetName'!$A:$K,11,FALSE)
The Formula I need:
Like =Vlookup(A1,GetPathofFileVariable(SomeFileVariable) & SomeSheetname!$A:$K,11,FALSE)
Last edited: