Change in Drop-Down List = Change in Value?

[PGrabiec]

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 I select Venue X it should cost $40 and if I select Venue Y it should cost $80.

Would this be possible?

Thanks,

 

[JonXL]

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 I select Venue X it should cost $40 and if I select Venue Y it should cost $80. Would this be possible? Thanks,

If B1 is the cell where you want the cost and A1 is the cell where your selections are, enter this formula in B1:

=IFERROR(VLOOKUP(A1,{"Venue X",40;"Venue Y",80},2,FALSE),"")

For additional venues/prices: enter the venue first in quotes, followed by a comma (,) and then the price. Separate each grouping by a semi-colon (; ).

ABE: I see you were also asking about making the drop-down list; select cell A1 based on my example above and click the Data tab; click data validation; select List; enter your values without quotes separated only by a comma (,): Venue X,Venue Y,Venue Z

https://support.office.com/en-us/ar...to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249

 

[Ron Coderre]

First, I created this table (named tblVenues):

Venues	Cost
Alpha	40
Bravo	80
Charlie	100

<tbody>
</tbody>

Then I assigned the name LU_Venues to the first column of that table

Next, I set up a data validation in cell B3 that references the LU_Venues list

Last, I put this formula in C3:

=IFERROR(VLOOKUP(B3,tblVenues,2,0),"<-Select venue")

Is that something you can work with?