Software

Ask something
Question Locked

Excel 2003 - Assigning values in the dropdown list

0 helpful
4 replies

by jmerrea

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I really can't figure this out. I just made a dropdown list using the Data > Validation which the source was targeted in a diffrent worksheet. What I wanted to do is to assign each choices in the dropdown menu with a specific numerical value.

eg. if the selected choice in the dropdown is "Apple", then the value of "Apple" is "1" or if the choice is "Banana", then the value of "Banana" is "2" and after that, it will summarize how many people in the list chose "Apple" and the "Banana".
Is this possible?

4 replies

by deanna_miles

I am having the exact same thing. If you did figure it out can you share you results. I would really appreciate it!
Thanks

by rl_styx

YOU SHOULD MAKE AN "IF" FUNCTIONS ONTO YOUR "SOURCE BAR" IN THE DATA VALIDATION LIST.. EG. TYPE =IF(A1="APPLE","1",IF(A1="BANANA","2"....),0)))....

EMAIL ME IF YOU ALREADY SOLVED IT..

by contact4manoj

Try using the VLOOKUP() or HLOOKUP() function. You can use the TEXT() function to get the value of the selected item in the cell containing the dropdown list, and then use that to do a cross-table retrieval from the Data Area specified in the VLOOKUP() or HLOOKUP() functions.

Happy coding!

Regards,

MANOJ KUMAR SHARMA.

This discussion is closed to new replies.