=INDIRECT(Formula()&"!A4")

HTH
--
AP

"Scott Morton" a
écrit dans le message de news:
...

I have a formula that works out a value - that value is also the name of
a worksheet, Can I do a lookup to a worksheet from that formula:
e.g.

Script number = 1.1 (Formula value = 1.1)

Now I want insert from cell "A4" in worksheet "1.1" (Fornula result)

Is this possible?

Hope I have explained it clearly enough.

Thanks in advance


--
Scott Morton
------------------------------------------------------------------------
Scott Morton's Profile:
http://www.excelforum.com/member.php...o&userid=35707
View this thread: http://www.excelforum.com/showthread...hreadid=554913