VLOOKUP multiple matches in target list

G

garrytagg

New Member
Joined
Aug 13, 2017
Messages
2
Operator NumberOperator NameOrder Number SO
100302GRISMER, GARY L41814521888173
395660FOUST, JAMES42323831914638
395660FOUST, JAMES42323831914638
100171HANKE, BARRY M42323831914638
380710EXTINE, CHRISTOPHER42332611915051
100139WATKINS, TIMOTHY L42332621915051
380710EXTINE, CHRISTOPHER42332631915051
100171HANKE, BARRY M42332641915051
100171HANKE, BARRY M42332641915051
380710EXTINE, CHRISTOPHER42332651915051
100171HANKE, BARRY M42332661915051
100131HARTMAN, RICKY D42390301916835
100131HARTMAN, RICKY D42390301916835
100102AMBURGEY, MICHAEL C42401491917707
100102AMBURGEY, MICHAEL C42402881917773
100102AMBURGEY, MICHAEL C42402881917773

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
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?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
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.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,215,563
Messages
6,125,554
Members
449,237
Latest member
Chase S

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top