how to use a cell to enter a filename in a formula

[John]

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?

[paul]

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!



"John" wrote:

> 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?

[John]

Thanks Paul, I'll try that.

"paul" wrote:

> 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!
>
>
>
> "John" wrote:
>
> > 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?