formula help creating drop down selection influencing another cell.

Copper Contributor

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?

1 Reply

@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, "")