Hi Steve,

Is this what you seek?

In a workbook on sheet1, i placed an active x combobox from the
control toolbox over cell a3.

On Sheet2 in cells a1:a3, I put a list of names

then back on sheet1, I populated cells a4:a17 with names.

and in cell c4, I entered this formula: =IF(A5=$A$4,"B","C") and
copied down to cell c18.

Dan