software

I am building a filename from two cells(A2, B1) and concatenating them into a
third cell(F2). How do use this third cell in a formula in a forth cell(B2)
to bring a figure from the file named in the third cell?

the indirect function will turn a text reference to a result but it will only
work if the remote workbook is open.
--
paul
remove nospam for email addy!
quot;Johnquot; wrote:

gt; I am building a filename from two cells(A2, B1) and concatenating them into a
gt; third cell(F2). How do use this third cell in a formula in a forth cell(B2)
gt; to bring a figure from the file named in the third cell?

Thanks Paul, I'll try that.

quot;paulquot; wrote:

gt; the indirect function will turn a text reference to a result but it will only
gt; work if the remote workbook is open.
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Johnquot; wrote:
gt;
gt; gt; I am building a filename from two cells(A2, B1) and concatenating them into a
gt; gt; third cell(F2). How do use this third cell in a formula in a forth cell(B2)
gt; gt; to bring a figure from the file named in the third cell?