Multiple VLookup Results

[Franz]

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
	A	B	C	D	E	F	G
1	S.O.	CUST.	DATE	Qty	P/N	REV	P.O.
2	73026	HSF	3/17/2003	1	796817-7	J*	1225822
3	73072	DAC	1/10/2003	114	6625493	D	707323
4	73073	DAC	1/10/2003	114	6625494	D	707323
5	73076	DAC	2/5/2004	42	6625493	D	TBN
6	73079	DAC	2/5/2004	42	6625494	D	TBN
7	73080	DAC	3/14/2003	56	7010721	A	707324
8	73081	DAC	3/14/2003	56	7010721-1	A	707324
9	73082	DAC	3/21/2003	336	7010735-1	B	707324
Sheet1

OrderEntrySearch.xls
	B	C	D	E	F	G
2	Search&BySpecificP/NorS.O.
3
4	EnterS.O.	P/N	Cust.	Qty.	Rev	P.O.
5	73072	6625493	DAC	114	D	707323
6	;	;	;
7	Enter;P/N	S.O.	Cust.	Qty.	Rev	P.O.
8	6625493	73072	DAC	114	D	707323
9	;	;	;	;	;
Sheet1

 

[DRJ]

Have you tried a pivot table?

 

[Franz]

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.