Forum Discussion
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?
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, "")