Hi!

Try this:

=INDIRECT("Sheet2!C"&A1)

Biff

"Kanga 85" wrote in message
...
On Sheet1 I have in Cell A1 a variable number, say 100.
In cell A2 on Sheet1 I wish to place the value of the cell in Sheet2 C100,
where the 100 is the value obtained from "Sheet1"A1.

Any help would be appreciated thanks.