I have made a drop down list to select different (text) names. Is there a way
to make each name correspond to a different number and place that number in a
different cell

For ex.

Cell # A1 Cell # A4
Chad 2
Nick 12
Jason 118