Pulling info based on dropdown selection with duplicates

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.

 

Data Table

item # Dropdown descroption Unit

1 White paint SF

2 Yellow paint LS

3 White paint LS

4 Yellow paint SF

 

Coversheet

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.  




By: Jake

Leave a Reply

Your email address will not be published. Required fields are marked *