Hello,
Can anyone tell me how I can assign a value to a word from a dropdown
list in excel?
In other words if I choose an item from the dropdown list, how can I
assign a static value to it?
An example would be if I select the item "apple" from the list, it
would automatically assign the number 5 to it that I can use in a
formula.
Thanks in advance.