Feb 28 2023 04:57 PM
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 |
Feb 28 2023 06:32 PM
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),"")
Feb 28 2023 06:33 PM