I would like the create a column that performs the following function:

[If column A=1, then display number in cell B10; If Column A=2, then display
number in cell B11, If column A=3; then display number in cell B12]

If it is of any importance, in the above example B10:12 have a
=SUMIF/COUNTIF function in them.

Thanks in advance.

AAA1986 wrote:
I would like the create a column that performs the following function:

[If column A=1, then display number in cell B10; If Column A=2, then display
number in cell B11, If column A=3; then display number in cell B12]

If it is of any importance, in the above example B10:12 have a
=SUMIF/COUNTIF function in them.

Thanks in advance.


=INDEX(B10:B12,A1)

=OFFSET(B10,A1-1,0,1,1)

=INDIRECT("B"&A1+9)

=IF(A1=1,B$10,IF(A1=2,B$11,IF(A1=3,B$12,"whatever you want if it isn't any
of those")))
--
David Biddulph

"AAA1986" wrote in message
...
I would like the create a column that performs the following function:

[If column A=1, then display number in cell B10; If Column A=2, then
display
number in cell B11, If column A=3; then display number in cell B12]

If it is of any importance, in the above example B10:12 have a
=SUMIF/COUNTIF function in them.

Thanks in advance.

Perfect! Thank you.

"David Biddulph" wrote:

=IF(A1=1,B$10,IF(A1=2,B$11,IF(A1=3,B$12,"whatever you want if it isn't any
of those")))
--
David Biddulph

"AAA1986" wrote in message
...
I would like the create a column that performs the following function:

[If column A=1, then display number in cell B10; If Column A=2, then
display
number in cell B11, If column A=3; then display number in cell B12]

If it is of any importance, in the above example B10:12 have a
=SUMIF/COUNTIF function in them.

Thanks in advance.


.