Is there any way to lookup multiple answers to a lookup formula.
Normally,
Excel will stop at the first match it finds and return that as the
answer
when, in fact, there may be more than one answer. I want to find the
other
matches as well and list them separately.

Here's an example.


Part No. Work Order
123 6000
123 6010
130 7000
135 7050


Part No. 123 has 2 (production) work orders associated with it: 6000
and
6010. I want to do a lookup of Part No. 123 and find ALL the work
orders
associated with it (listed separately, of course). Is there any way
to do
I want Data Excel sheet2?

Pls help Me