In my excel project, I've created a drop down menu in one cell. In the
adjacent cell, I want to have answers automatically generated when you choose
one of the choices in the drop down menu. For example, in the drop down menu
I have:

DROP DOWN MENU SCORE
Ideal Client 3
Handholding 2
Not Ideal 1

If I chose Ideal Client from the drop menu, I want the next cell to
automatically give the score of 3. How can I do this?