View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Popik Popik is offline
external usenet poster
 
Posts: 2
Default 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.