Bring Back Multiple Items Based on Common Number

I have a spreadsheet that lists part numbers part, part description, etc and three separate worksheets that list the part number as well as the customers associated with that part number. What I need is a script that will search for the part number and bring back every instance of the customer name. I can't do this with a vlookup as there may be more than one customer that uses any single part number. Any ideas? I am a novice when it comes to scripting.

While that would work, I have 10000 part numbers and my three different of part numbers/customer names contain a total of 131,952 rows. What I need is something that will bring me back the customer names on the sheet with the 10000 part numbers efficiently, so that I don't have to filter by hand.

Anyone? I can't use an index formula since my data spreads out over multiple sheets. Thanks.

Originally Posted by 3ric

I have a spreadsheet that lists part numbers part, part description, etc and three separate worksheets that list the part number as well as the customers associated with that part number. What I need is a script that will search for the part number and bring back every instance of the customer name. I can't do this with a vlookup as there may be more than one customer that uses any single part number. Any ideas? I am a novice when it comes to scripting.

Can you post a sample of your workbook?