Try this:
=INDIRECT(C1&"!A1")
And copy down.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"atran" wrote in
message ...
Is it possible to have a sheet reference in a formula that is based on a
referenced cell?
For example, if I have the following formula in cell A1(Sheet1):
=Sheet2!A1, then I have a list of Sheets ie. Sheet 3, Sheet 4, Sheet 5
in cells C1:C3 respectively, can I create a formula that will look at
C1:C3 for the corresponding "sheet reference" to look up?
Many thanks!
--
atran
------------------------------------------------------------------------
atran's Profile:
http://www.excelforum.com/member.php...o&userid=24540
View this thread:
http://www.excelforum.com/showthread...hreadid=381592