This is why autofilter exist. Try that or use advanced filter and copy
somewhere else to create sub lists
There are ways of doing it with formulas (somewhat complicated) but it is
far better to use a filter

--

Regards,

Peo Sjoblom


wrote in message
...
Is there any way to use lookup formulas to have Excel
find ALL of the values associated with the lookup
parameter and somehow list them out? Here's an example:

A B
Part No. Work Order
1 123 8000
2 123 8001
3 456 8002
4 789 8003

I want to know ALL of the production work orders (col. B)
that are open for a given product (col. A). Is there a
way to do a lookup on part no. 123 (A1) where Excel would
return both of the open work orders 8000 and 8001?

Thanks.