Lookup with multiple results

As I said before, I don't know much about Pivot Tables, but I know there is
an option to double click on the data label so that you can change the
manner in which it is presented.
When you drag Part Number into the data field, doesn't it say SUM ?
Double click on this and play around with the different options.

With all my inexperience, I was able to list out your part numbers without
them being totaled, and they were listed next to the Work orders also.

This is definitely the way you want to go (Pivot Tables).
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill" wrote in message
...

This is an excellent suggestion and would be the simplest
solution of all - if it worked. I just tested this,
however, and it seems that Excel doesn't like text in
pivot tables. Even after reformatting the work order
numbers to text, Excel still treated them like numbers
(and added duplicates together). So then I tried using
letters to represent work orders instead of numbers. The
pivot table returned zeroes, so the letters were
apparently just ignored. Keep thinking!