Re: Dynamic Formula?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Try this:

=INDIRECT(C1&"!A1")

And copy down.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"atran" <atran.1r34bz_1119539269.1994@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:atran.1r34bz_1119539269.1994@xxxxxxxxxxxxxxxxxxxxxxxx

Is it possible to have a *** 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 "*** reference" to look up?

Many thanks!


--
atran
------------------------------------------------------------------------
atran's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24540
View this thread: http://www.excelforum.com/showthread.php?threadid=381592


.

Quantcast