Forum Discussion

Winemakermama's avatar
Winemakermama
Copper Contributor
Mar 02, 2023

formula help creating drop down selection influencing another cell.

I need to make a drop-down selection influence the formula in another cell.  

I would like the drop-down selection to then populate the price of that item in another cell.  How do I write that?

excel

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 03, 2023

    Winemakermama 

    I assume that the source of the drop down list is a range in a column somewhere.

    Enter the corresponding prices in the column immediately to the right.

    You can then use a formula of the form

     

    =IFERROR(VLOOKUP(dropdown_cell, item_and_price_range, 2, FALSE), "")

     

    or

     

    =XLOOKUP(dropdown_cell, item_range, price_range, "")