Worksheet from Formula

S

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
 
M

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