R
Ranjit S Hans
Hi Excel Gurus,
How do I calculate a value on a new cell based on what the user selects from
a List.
For Example :
If I have a dropdown List of 5 items -> APPLE, ORANGE, BANANA, GRAPES,
PINEAPPLE
Selecting APPLE should paste a value 1 in the adjoining cell
Selecting ORANGE should paste a value 2 in the adjoining cell
Selecting BANANA should paste a value 3 in the adjoining cell
Selecting GRAPES should paste a value 4 in the adjoining cell
Selecting PINEAPPLE should paste a value 5 in the adjoining cell
Thanks for your time.
Warm Regards,
Ranjit S Hans
How do I calculate a value on a new cell based on what the user selects from
a List.
For Example :
If I have a dropdown List of 5 items -> APPLE, ORANGE, BANANA, GRAPES,
PINEAPPLE
Selecting APPLE should paste a value 1 in the adjoining cell
Selecting ORANGE should paste a value 2 in the adjoining cell
Selecting BANANA should paste a value 3 in the adjoining cell
Selecting GRAPES should paste a value 4 in the adjoining cell
Selecting PINEAPPLE should paste a value 5 in the adjoining cell
Thanks for your time.
Warm Regards,
Ranjit S Hans