ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   indirect.ext question (https://www.excelbanter.com/excel-discussion-misc-queries/60452-indirect-ext-question.html)

Dave K

indirect.ext question
 
I am having one minor issue with the indirect.ext function. Everything works
great when I type in this:

=VLOOKUP("Net
Worth",INDIRECT.EXT("'I:\EXCEL\SPREADS\PFS-PCF\[bishope.xls]pfs'!a9:f45"),2,FALSE)

What I really need to do is change the file name based on the value of a
nearby cell. For instance,
=VLOOKUP("Net
Worth",INDIRECT.EXT("'I:\EXCEL\SPREADS\PFS-PCF\[A2.xls]pfs'!a9:f45"),2,FALSE)
Where A2 contains the name bishope.

Obviously, that will not work. How can I make it work?

Thanks in advance!


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com