Worksheet from Formula

[Scott Morton]

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

[Ardus Petus]

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

HTH
--
AP

"Scott Morton" <[email protected]> a
écrit dans le message de news:
[email protected]...
>
> 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
>

[Max]

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
>
>