Hello,

I have a cell in excel where in I have created a drop down menu.

The choices in the dropdown menu are: A, B, and C.

What I would like, in another cell, is that when the user chooses A, B, or C, for it to output a number in the output cell based on their choice.

I have figured out one way to do it, assuming I only have 2 selections, by using an =IF formula, (using true for the first option and false for the second option,) but that's kind of a workaround for what I'm sure excel can do in another way.

Does anyone know how to do this? (Why do I even ask this? You people are brilliant!)