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 ... n...
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),"")