I would like to build a vlookup that its source data (table array source file) will be dynamic (the sheet name and range aren't dynamic).
I want to enter on one cell the path where the file is located, in second cell the constant part of the file name and in third cell a number - that will be updated and will reflect the updated file revision. for example:
I would like to build the following vlookup:
I want to place the path (D:\Projects\Templates\) on one cell, the first part of the file name (csdm_PLM_v) on the 2nd cell and the ver number (21) in a 3rd cell. the ver number will be changed frequently and I want the function to be dynamic.
If my worksheet looks like:
Path | filePrefix | Version
--------------------------------
D:\Projects\Templates\ | csdm_PLM_v | 21
How can I make the following vlookup dynamic:
Thanks
I want to enter on one cell the path where the file is located, in second cell the constant part of the file name and in third cell a number - that will be updated and will reflect the updated file revision. for example:
I would like to build the following vlookup:
Code:
=VLOOKUP($D3,'D:\Projects\Templates\[csdm_PLM_v21.xls]Relevant'!$A$4:$AA$202,3,0)
If my worksheet looks like:
Path | filePrefix | Version
--------------------------------
D:\Projects\Templates\ | csdm_PLM_v | 21
How can I make the following vlookup dynamic:
Code:
=VLOOKUP($D3,'D:\Projects\Templates\[csdm_PLM_v21.xls]Relevant'!$A$4:$AA$202,3,0)
Thanks