Forum Discussion
Dropdown list with a second column
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 |
- 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? 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),"")
