Thread: Drop down list to numbers

Hello,

I have a questionnaire spreadsheet in which numbers are used to rank the statements. However, I want to use a drop down list of answers in words, rather than numbers, but need these answers to create a predefined number in another cell.

For example the drop down list will have yes (3), no(1), partially(2) and not applicable (0) and when one is selected its associated number pops up in an adjacent cell.

Thanks in advance for your help.

Thanks a lot zbor, simple yet effective!