difficult Cell Reference problem

Mar 4th, 2002, 03:02 PM

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

Quote:

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

=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:02 PM	#1
Guest Posts: n/a	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.

Mar 4th, 2002, 03:07 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=INDIRECT("A"&20-B9)