Hi,
I created a drop box that has 4 possible responses. Each response has a weight on it. I would like to create a function/macro/code to update the table cell with that weighted value.

For example:

Select color (blue =1, red =2, yellow =3) - Users selects red - Output = 2
Select Town (Boston=1, New York=2, LA = 3) - Users selects LA - Output = 3


etc... -----------------
Final Score = 5


Thanks