VLOOKUP multiple matches in target list

[garrytagg]

[TABLE="width: 412"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Operator Number[/TD]
[TD]Operator Name[/TD]
[TD]Order Number[/TD]
[TD] SO[/TD]
[/TR]
[TR]
[TD="align: right"]100302[/TD]
[TD]GRISMER, GARY L[/TD]
[TD="align: right"]4181452[/TD]
[TD="align: right"]1888173[/TD]
[/TR]
[TR]
[TD="align: right"]395660[/TD]
[TD]FOUST, JAMES[/TD]
[TD="align: right"]4232383[/TD]
[TD="align: right"]1914638[/TD]
[/TR]
[TR]
[TD="align: right"]395660[/TD]
[TD]FOUST, JAMES[/TD]
[TD="align: right"]4232383[/TD]
[TD="align: right"]1914638[/TD]
[/TR]
[TR]
[TD="align: right"]100171[/TD]
[TD]HANKE, BARRY M[/TD]
[TD="align: right"]4232383[/TD]
[TD="align: right"]1914638[/TD]
[/TR]
[TR]
[TD="align: right"]380710[/TD]
[TD]EXTINE, CHRISTOPHER[/TD]
[TD="align: right"]4233261[/TD]
[TD="align: right"]1915051[/TD]
[/TR]
[TR]
[TD="align: right"]100139[/TD]
[TD]WATKINS, TIMOTHY L[/TD]
[TD="align: right"]4233262[/TD]
[TD="align: right"]1915051[/TD]
[/TR]
[TR]
[TD="align: right"]380710[/TD]
[TD]EXTINE, CHRISTOPHER[/TD]
[TD="align: right"]4233263[/TD]
[TD="align: right"]1915051[/TD]
[/TR]
[TR]
[TD="align: right"]100171[/TD]
[TD]HANKE, BARRY M[/TD]
[TD="align: right"]4233264[/TD]
[TD="align: right"]1915051[/TD]
[/TR]
[TR]
[TD="align: right"]100171[/TD]
[TD]HANKE, BARRY M[/TD]
[TD="align: right"]4233264[/TD]
[TD="align: right"]1915051[/TD]
[/TR]
[TR]
[TD="align: right"]380710[/TD]
[TD]EXTINE, CHRISTOPHER[/TD]
[TD="align: right"]4233265[/TD]
[TD="align: right"]1915051[/TD]
[/TR]
[TR]
[TD="align: right"]100171[/TD]
[TD]HANKE, BARRY M[/TD]
[TD="align: right"]4233266[/TD]
[TD="align: right"]1915051[/TD]
[/TR]
[TR]
[TD="align: right"]100131[/TD]
[TD]HARTMAN, RICKY D[/TD]
[TD="align: right"]4239030[/TD]
[TD="align: right"]1916835[/TD]
[/TR]
[TR]
[TD="align: right"]100131[/TD]
[TD]HARTMAN, RICKY D[/TD]
[TD="align: right"]4239030[/TD]
[TD="align: right"]1916835[/TD]
[/TR]
[TR]
[TD="align: right"]100102[/TD]
[TD]AMBURGEY, MICHAEL C[/TD]
[TD="align: right"]4240149[/TD]
[TD="align: right"]1917707[/TD]
[/TR]
[TR]
[TD="align: right"]100102[/TD]
[TD]AMBURGEY, MICHAEL C[/TD]
[TD="align: right"]4240288[/TD]
[TD="align: right"]1917773[/TD]
[/TR]
[TR]
[TD="align: right"]100102[/TD]
[TD]AMBURGEY, MICHAEL C[/TD]
[TD="align: right"]4240288[/TD]
[TD="align: right"]1917773[/TD]
[/TR]
</tbody>[/TABLE]
I'd like to be able to extract the order #s in the first column of numbers from a very large spreadsheet. VLOOKUP would be the obvious solution; however, a work order may be listed numerous times, and VLOOKUP only picks up the first item it sees. The first column is work orders, the second is sales orders. The sales orders appear multiple times also, as there are often numerous shipments against the same order. Any ideas of a way to accomplish this?

 

[Aladin Akyurek]

Your description in words does not seem to agree with the sample you posted...

 

[garrytagg]

Thank you for trying to help, Aladin. My sample is from a list of orders that passed thru a particular work center in our shop. I want to find them in a worksheet of sales for the entire year (350,000 lines) that include my sample. If I use VLOOKUP on the 350,000 list, it will only return the first of numerous duplicate items in my sample. You can see an example of work orders listed more than once, and sales orders listed more than once. Also sales orders listed more than once, but with different corresponding work orders. I can key off either column. How can I find my sample items in the larger population?

Thanks again for offering your help.

 

[Aladin Akyurek]

Care to post a concise input sample and the output that goes with that input?