Drop down menu in excell - change values in another cell

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

  1. satanicoo

    satanicoo n00b

    Messages:
    52
    Joined:
    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.

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

    Any idea?
     
  2. Eulogy

    Eulogy 2[H]4U

    Messages:
    2,201
    Joined:
    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.

    =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.