Use INDIRECT function
It basically lets you use it in VLOOKUP to point to a cell which can have a
formula to generate the filename...

"mdhodgson" wrote:

Hello,
I need a vlookup pathname to be found in a cell. Is this possible? for
instance:
=vlookup(a2, " value found in another cell " , 2,false). The folder, tab,
cells are always the same. The only varience is the workbook name.

I've looked on forums to try and help they all suggest other addins. I'm not
too keen to install them as it is a work computer.

Thank you