Help!!! Cell Location From Formula

[Henry1807]

Hey All,

Usually, people use cell locations in formulas. Anyone know how to use a formula in a cell location?

For example:

C1 is 5
C2 is 10
C3 is 12

I want D{C2}=C1+C3.
In other words D10=C1+C3.

So I want to use C2 in the location of the D cell. Does this make any sense, and if so, is there a way to do that in Excel?

Thanks.

Henry

 

[PaddyD]

=INDIRECT("D"&C2)

 

[Henry1807]

PaddyD,

Thanks a million for the incredibly fast solution!

Henry

 

[PaddyD]

seven minutes is sloooowwww

paddy