Excel and drop down list

[eleftheriak]

Hello,

I would like to have a drop down list and whichever field i m choosing
automatically to put inside a shell a number that is associated with
this field. For example, if i select ice cream from the list I should
get in A1 the number 5.

Thanks in advance
Riri

 

[Tom Ogilvy]

See Debra Dalgleish's pages on Data => Validation

http://www.contextures.com/xlDataVal01.html

and see if there is something there you can use. I suspect you might want
to combine data validation with the vlookup worksheet function.