I am trying to make a dropdown selection pull data from a table in its corresponding row, and the dropdown has duplicates. The data table to pasted into a tab.
item # Dropdown descroption Unit
1 White paint SF
2 Yellow paint LS
3 White paint LS
4 Yellow paint SF
Item # Description (dropdown) Unit
So when a person selects white paint (item 1) from the table in the dropdown, it fills in item number and unit. There will be duplicates, and thats the challenge. This data has to only match the option in the chart as its prepairing a .csv export file for an ERP system.