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.