Drop down menu in excell - change values in another cell

satanicoo

n00b
Joined
Jun 11, 2004
Messages
54
Greetings guys,

Can you give me a hand, i made a drop down menu in excell, but i wanted to have another cell show a diferent value, accordingly to the option i choose on the drop down menu.

Example:
-I choose bread, the second cell shows 324
-I choose butter, the second cell shows 210

Any idea?
 
If it's a simple A/B like you have (i.e. only two options), I'd probably just do an IF.

=IF(A1="Bread",324,210)

It still remains pretty simple and legible even if there's three options, like, tomato as well:

=IF(A1="Bread",324,(IF(E26="Tomato",250,210)))

But beyond that it gets pretty ugly with all the nested IFs and I would go a different route.
 
Back
Top