| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display the pathname/address of a hyperlink? | Excel Worksheet Functions | |||
| How do use listed pathname to link values from another workbook? | Excel Discussion (Misc queries) | |||
| Using a dynamic pathname in VLOOKUP | Excel Worksheet Functions | |||
| Using a variable to represent the pathname in a formula | Excel Discussion (Misc queries) | |||
| Full Pathname in Titlebar | Setting up and Configuration of Excel | |||
Hybrid Mode
