Mar 02 2023 07:02 PM
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?
Mar 03 2023 04:29 AM
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, "")