calculate a value on a new cell based on the list

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
 
E

Eduardo

Hi,
Let's say you have your list in column A and the values in column B, in Cell
E3 you have your data validation arrow so in cell F3 you enter

=+VLOOKUP(E3,A1:B10,2,FALSE)

Each time you select a different item in column E it will bring the right
value in column F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top