Cell reference problem

Mar 4th, 2002, 03:09 PM

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. · Mar 4th, 2002, 03:17 PM

=INDIRECT("A"&20-B9)

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

Aladin Akyurek · Mar 4th, 2002, 03:17 PM

Quote:

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 03:09 PM	#1
Guest Posts: n/a	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.

Mar 4th, 2002, 03:17 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=INDIRECT("A"&20-B9) Note: It's best not to start a new thread.