Dropdown list with a second column

[Jennifer26]

Hi there

I have a list of events and costs. In selecting the event option in a dropdown list how can the corresponding $ be listed in the adjacent cell. (can do the single column dropdown list ... not sure about the double column list :))

eg: 

Movies	$22
Museum/gallery	$25
Park	$25
Picnic	$30

[#2]

@Jennifer26 

You have to create a Reference/LookUp Table and use VlookUp() function to get the amount associated with the selected item from the dropdown.

refer this formula from the below image:

=IFNA(VLOOKUP(A3,$G$3:$H$6,2,0),"")

[#3]

9.23 jPX:/ https://v.douyin.com/SYm7Gou/

how combine name and costs in one word as the option of drop down and then split to 2 columns?