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.