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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]PO Number[/TD]
[TD]Trking Number[/TD]
[TD]PO[/TD]
[TD]Trk[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4501409946
[/TD]
[TD]483713277091[/TD]
[TD]4501409946[/TD]
[TD]483713227091, 483713277080, 483713277070, 483713277069[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4501409946[/TD]
[TD]483713277080[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4501409946[/TD]
[TD]483713277070[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4501409946[/TD]
[TD]483713277069[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]4501409965
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]4501409965[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]4501409965[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]4501409965[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]4501409935[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]4501409935[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]4501409935[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]4501409935[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]4501409935[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]4501409935[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]4501409935[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]4501409822[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]4501409822[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]4501409822[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]4501409822[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.