vlookup dynamic pathname
 

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

vlookup dynamic pathname
 

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

vlookup dynamic pathname
 

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

"Chip Pearson" wrote:

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)

vlookup dynamic pathname
 

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

Keep up the good work.
Mukesh





"Sheeloo" wrote:

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

"Chip Pearson" wrote:

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)