Worksheet from Formula
 

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

Worksheet from Formula
 

=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

Worksheet from Formula
 

Assuming your formula is in A1 (evaluates to: 1.1)
then we could put in B1: =INDIRECT("'"&A1&"'!A4")
to retrieve the contents in 1.1's cell A4
(B1 returns the same as the link formula: ='1.1'!A4)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Scott Morton" wrote:

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