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.