Calculating a cell address

[Jeff Hooper]

I need to refer to the contents of a cell, the address of which is to be
calculated from data within the worksheet. For example:

A B C D E
1 4 x
2
3
4
5
6 22

I want the contents of cell E1 to be equal to the contents of the cell in
column A and the row determined by the contents of cell D1+2 (ie E1 = 22,
the contents of cell A,6). Any ideas?

Thanks

 

[Leo Heuser]

Jeff

Here are two ways to do it:

=OFFSET(A1,D1+1,0)
(+1 because OFFSET is zero-based)

or

=INDIRECT("A"&D1+2)