Thanks a lot!

This worked as long as the column (C) was in the same worksheet. What about
if the column is in another worksheet or file?

-Piia

"Mike H" wrote:

Try

=INDIRECT("C"&A1)

Mike

"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