dynamic cell reference

[ottok]

Hello,

I want to refer to a cell, where the cell row number is contained i
separate cell, and can be changed.
Anybody knows a good way to achieve this ?
Thanks,
Ott

 

[Peo Sjoblom]

A couple of ways

=INDIRECT("A"&B1)

and

=OFFSET($A$1,B1-1,)

and

=INDEX(A:A,B1)

where you would put the row number in B1 and in this example the range would
be column A

the last formula might be a better choice since it is not volatile

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[ottok]

Thanks,
That's was for what I was looking
Otto

*A couple of ways

=INDIRECT("A"&B1)

and

=OFFSET($A$1,B1-1,)

and

=INDEX(A:A,B1)

where you would put the row number in B1 and in this example th
range would
be column A

the last formula might be a better choice since it is not volatile

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)