Advanced Cell Reference
 

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.

Advanced Cell Reference
 

Try this: =INDIRECT("B"&ROW()+A1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Popik" wrote in message
...
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.

Advanced Cell Reference
 

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

=INDIRECT("B"&ROW()+A1)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Popik" wrote in message
...
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.