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

368 thoughts on “Pulling info based on dropdown selection with duplicates

  1. Eva Faehnle

    The small boat set sail in the port of youth. We broke up at the right time, full of ambition and pursuit. When will they reunite? It will be at that harvest!

  2. sling tv

    Hello! Do you know if they make any plugins to safeguard
    against hackers? I’m kinda paranoid about losing
    everything I’ve worked hard on. Any recommendations?

  3. Tim Arntt

    Tomorrow will be a long journey, tonight without sleep, I do n’t know when to see you on this trip, I miss it, and send my most sincere wishes to my best friend!

Leave a Reply

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