Vlookup, concantenate multiple results... Help!

[bobletcs123]

Good Morning All,

Having trouble getting multiple results from a Vlookup. Using Excel 16.

Have list with po numbers and they have multiple tracking numbers. Would like to be able to look up po on separate sheet and have all the associated tracking numbers concatenated there... Maybe i should just pivot the PO and try and concatenate the tracking, then do Vlookup? Either way, getting kind of lost. Any help would be greatly appreciated. Looked at a few things on forum and none of those worked for me.

EX: A is PO (could be pivoted), B is All tracking number associated.
Results = C (A) and D, concatenated tracking (B concatenated).

Eventually want to look up to other sheet for cust that i can just reference PO and pull concatenated tracking for them.

	A	B	C	D
1	PO Number	Trking Number	PO	Trk
2	4501409946	483713277091	4501409946	483713227091, 483713277080, 483713277070, 483713277069
3	4501409946	483713277080
4	4501409946	483713277070
5	4501409946	483713277069
6	4501409965
7	4501409965
8	4501409965
9	4501409965
10	4501409935
11	4501409935
12	4501409935
13	4501409935
14	4501409935
15	4501409935
16	4501409935
17	4501409822
18	4501409822
19	4501409822
20	4501409822

<tbody>
</tbody>

Thank you in advance!

 

[CyrusTheVirus]

D2 (Entered with Ctrl+Shift+Enter):

=TEXTJOIN(",",TRUE,IF(C2=$A$2:$A$20,$B$2:$B$20,""))

 

[bobletcs123]

D2 (Entered with Ctrl+Shift+Enter):

=TEXTJOIN(",",TRUE,IF(C2=$A$2:$A$20,$B$2:$B$20,""))

Thank you so much! Worked like a charm.
I was going nuts over here trying to get something to work.
Much appreciated

 

[CyrusTheVirus]

You're welcome.