I have a worksheet in which I want to add vlookup function where the table array will be taken dynamically from concatenated path.
I want to store the path in one cell, the filename prefix in another cell, the file name suffix in a 3rd cell and the sheet and range in a 4th cell.
How to do that?
Thanks
Bookmarks