difficult Cell Reference problem

[Guest]

I would like cell B10 to display the contents of the cell with Column A and (row 20 - the number in cell B9)

Example:
If cell B9 contains the value 3
I would like cell B10 to display the value of A(20-3) or A17

Thanks.

 

[Aladin Akyurek]

On 2002-03-04 14:02, Anonymous wrote:
I would like cell B10 to display the contents of the cell with Column A and (row 20 - the number in cell B9)

Example:
If cell B9 contains the value 3
I would like cell B10 to display the value of A(20-3) or A17

Thanks.

="A"&20-B9

 

[Mark W.]

=INDIRECT("A"&20-B9)