vlookup dynamic pathname

[mdhodgson]

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

 

[Sheeloo]

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...

 

[Sheeloo]

Hello CHip,

Just wanted to thank you. I am a great fan of your website on Excel. It has
taught me great things and saved hundreds of hours...

Regards,
Vinamra

 

[Mukesh]

I second that.
Your website is an excellent place to get help on excel.

Keep up the good work.
Mukesh

Hello CHip,

Just wanted to thank you. I am a great fan of your website on Excel. It has
taught me great things and saved hundreds of hours...

Regards,
Vinamra

You can use the INDIRECT function. For example,

=VLOOKUP("a",INDIRECT("["&F3&"]Sheet1!A1:B10"),2,FALSE)

This will take the workbook name from cell F3. Note that INDIRECT requires
that the file named in F3 be open. INDIRECT does not work with closed files.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)