How about a userform with listboxes.

check out
http://www.geocities.com/excelmarksway

for mutiple auto filter

or send me workbook and maybe I can design a feature for you.

- - Mark


"Larry Banach" wrote:

I'm trying to set up a spreadsheet that will give me the multiple and
various results from a column in a spreadsheet.
Example spreadsheet:

col a col b
Part Tool
12345 12345
23456 23456
34567 34567
45678 34567
56789 56789
67890 56789
78901 56789

if I was to search for all parts made from tool 12345 the result should be
only part 12345, but if I searched for parts made from tool 56789, the
results I'm looking to see are 56789, 67890, and 78901. I was able using
index and match funtions to get a single answer but I would like to be able
to display all associated results on the single worksheet. Maybe it's some
kind of combination of if statements and index and match functions or find,
I'm not sure.

My spreadsheet has approximately 1000 part numbers made from several hundred
different tools.

Thanks in advance for the assistance.