PDA

View Full Version : Cell reference consisting of column and row



enfantter
11-13-2008, 01:45 PM
Hi all,
This question might be a bit of topic but i hope somebody can help me.
Let say that cell e1 has the value 71 - i want cell a to have the show the value of cell b71 (b is constant and 71 comes from e1). Cell a2 should then in the same way show b+e2.
Does anybody know if this is possible to directly in excel - without vba.
Would appreciate much - Enfantter

Bob Phillips
11-13-2008, 02:03 PM
=INDIRECT("B"&E1)