dynamic cell reference

O

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
 
P

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)
 
O

ottok

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


Peo said:
*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)
Click to expand...
 
Top