Thanks that works. But If the file that it links to is closed it doesn't
work. Would I have to include the filepath somehow? I tried C:\files\ in a
helper cell L2 and then changed it to =INDIRECT("'"&L2&L3&L4&"'"&"!$F$38")
but it just gives me #REF!




"David Billigmeier" wrote:

Ahh, yep, there it is... missing a quotation and an ampersand:

=INDIRECT("'"&L3&L4&"'"&"!F38")

--
Regards,
Dave


"DN" wrote:

Hi David,

Thanks for you quick reply but I still get an error and it highlights the
second set of "'" in the formula. Any thoughts?

"David Billigmeier" wrote:

You're close... you need one more function, INDIRECT():

=INDIRECT("'" & L3 & L4 & "'"!$F$38")

--
Regards,
Dave


"DN" wrote:

Hi,

I have two helper cells with values:
L3 = [Trials AM05 30Aug06.xls]
L4 = T AM06 A 30Aug06 usd

I am trying to recreate this:
='[Trials AM05 30Aug06.xls]T AM05 A 30Aug06 usd '!$F$38"

using:
="'" & L3 & L4 & "'"!$F$38" but it says there's an error.

What's wrong with my formula? Any help would be greatly apprciated.

Dave.