close

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

=VLOOKUP(quot;Net
Worthquot;,INDIRECT.EXT(quot;'I:\EXCEL\SPREADS\PFS-PCF\[bishope.xls]pfs'!a9:f45quot;),2,FALSE)

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

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

Thanks in advance!

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄