Drop-down list with names shown, but produces a numerical value in the cell for a formula

[TheUnconquered]

Hello,

I have created a drop-down list with five names or words. I wanted to see if there's a way to have the names show up for the user, but have a numerical value in that cell that would be used in a formula.

Thanks,
Blake

 

[Fluff]

Glad we could help & thanks for the feedback.