At 11:39 24/03/2009 -0700, Mark Phillips wrote:
How do I convert text in one cell into a reference to a particular
sheet and use that reference to get the data from a cell in that sheet?
[...]
For example, I have sheets summary, March 28, and April 1. In cell
summary.a1 I put the text field March 28. The cell summary.b1 should
now contain the data in March 28.a1. If I type April 1 as text in
cell summary.a1, I want to see the data in April 1.a1 in summary.b1.
How can I do this with a formula?
In summary.B1, put:
=INDIRECT(A1&".A1")
The argument concatenates your sheet name with the particular cell
reference; the INDIRECT() function then converts the resulting string
into the reference that you require.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
