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)