=INDIRECT("C" & A1)


Gord Dibben MS Excel MVP

On Tue, 12 Aug 2008 03:52:01 -0700, Piia
wrote:

Hi,

How can I get number in some cell to the number of some other cells reference?

For example, if I have calculation in cell A1 giving some number XX and I
want to refer in cell B1 to cell CXX (column C, row XX), how do I do this?

Thanks and bye,
Piia