Variable Cell Number?

Hi all,
I have a (tough?) question: is it possible to refer to a cell by a variable cell number? For example suppose i want to refer to a cell on column B, by a value which is in cell C1, so the if C1 has the value 7, i would refer to cell B7, abd if it has the value 87 i would refer to cell B87.

any ideas??

Hi talR

You need to use the indirect function

e.g.=Indirect("B"&C1)

Ed