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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top