Advanced Cell Reference

[Popik]

Hello,

Let me explain my question with an example. In cell A1, I have the value 2.
In cell B1, I would like to refer to the cell that is A1 cells away from it
in the B row; in other words, I would like B1 = B(1+A1). How can I call a
cell reference that accepts as a column indicator the value of a cell?

Thank you for your help.

 

[Bernard Liengme]

Try this: =INDIRECT("B"&ROW()+A1)
best wishes

 

[Ragdyer]

With 100 entered in B3,
and 2 entered in A1,
try this in B1 to display that 100:

=INDIRECT("B"&ROW()+A1)