Drop down menu in excell - change values in another cell

Discussion in 'General Software' started by satanicoo, Oct 15, 2019.

  1. satanicoo

    satanicoo n00b

    Jun 11, 2004
    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.

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

    Any idea?
  2. Eulogy

    Eulogy 2[H]4U

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


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


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