Hi,
I'm trying to create a drop down list with value changing in excel 2013.
Basically the goal is when I choose an option from the list, it changes it into a number.
The drop down list will be in a column that represents cities. I want to define numbers to the cities so when I go to a cell and choose a city from the list, it will change to the number I defined.
Is it possible?
Thanks in advance,
Liran.
I'm trying to create a drop down list with value changing in excel 2013.
Basically the goal is when I choose an option from the list, it changes it into a number.
The drop down list will be in a column that represents cities. I want to define numbers to the cities so when I go to a cell and choose a city from the list, it will change to the number I defined.
Is it possible?
Thanks in advance,
Liran.