Cell reference problem

[Guest]

Sorry, I wasn't clear enought before. I meant the contents ofthe cell as described below:

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 CONTENTS of cell A(20-3) or A17

Thanks.

 

[Mark W.]

=INDIRECT("A"&20-B9)

Note: It's best not to start a new thread.

 

[Aladin Akyurek]

On 2002-03-04 14:09, Anonymous wrote:
Sorry, I wasn't clear enought before. I meant the contents ofthe cell as described below:

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 CONTENTS of cell A(20-3) or A17

Thanks.

=INDIRECT("A"&20-B9)