and another

=CHOOSE(CODE(LOWER(B3))-96,0,1,2)

Mike

"Kuliano" wrote:

I have a drop down list in B3 with three (text) values - call then a, b, and,
c. Based on what a user selects in the drop down, I need to perform other
calculations:

If B3 = "a", I want to populate E3 with 0, or
If B3 = "b", I want to populate E3 with 1, or
If B3 = "c", I want to populate E3 with 2

I'm at a loss...