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):
[TABLE="width: 128"]
<tbody>[TR]
[TD]Venues[/TD]
[TD]Cost[/TD]
[/TR]
[TR]
[TD]Alpha[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Bravo[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD]Charlie[/TD]
[TD="align: right"]100
[/TD]
[/TR]
</tbody>[/TABLE]

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?