Hello,
I am planning a prom on Excel and I must calculate all of the costs of the prom.
I am trying to create a drop-down list which features all 3 available prom venues that can be selected. Upon changing the venue, I would like it to also change the price in the cell next to it. Basically if...