Multiple VLookup Results

Franz

Board Regular
Joined
Aug 12, 2002
Messages
90
Greetings, I was wondering if the experts could help me with this one. I have two workbooks ,orderlog which is the source data and order entry search which is the result data. If a user chooses to search the data by part number there can be more than one result with respect to S.O. The problem with VLookup is it displays the info for the first match (S.O.) it finds but will not go any further if there are other entries for the same part number. Is there a way around VLookup's limitation and display all data entries for the same part number? Hope the images below help Thanks.
OrderLog.xls
ABCDEFG
1S.O.CUST.DATEQtyP/NREVP.O.
273026HSF3/17/20031796817-7J*1225822
373072DAC1/10/20031146625493D707323
473073DAC1/10/20031146625494D707323
573076DAC2/5/2004426625493DTBN
673079DAC2/5/2004426625494DTBN
773080DAC3/14/2003567010721A707324
873081DAC3/14/2003567010721-1A707324
973082DAC3/21/20033367010735-1B707324
Sheet1
OrderEntrySearch.xls
BCDEFG
2Search&BySpecificP/NorS.O.
3
4EnterS.O.P/NCust.Qty.RevP.O.
5730726625493DAC114D707323
6;;;
7Enter;P/NS.O.Cust.Qty.RevP.O.
8662549373072DAC114D707323
9;;;;;
Sheet1
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Franz

Board Regular
Joined
Aug 12, 2002
Messages
90
No, I have not considered a pivot table. I will have to brush up on setting one up and seeing if it will work for my situation. Thanks for the tip.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,258
Messages
5,600,567
Members
414,389
Latest member
MarkElla

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
Top