What if they choose Oranges, and where are these static values stored? If
you have 7 or less, you can use an IF statement, but if you have more than
that, you're best to create a table somewhere and create a vlookup.
http://www.officearticles.com/excel/...soft_excel.htm
http://www.officearticles.com/excel/...soft_excel.htm
Walks you through a vlookup:
http://www.officearticles.com/tutori...excel.htm#boss

*******************
~Anne Troy

www.OfficeArticles.com



wrote in message
oups.com...
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.