Return all Vlookups and concatenate/join within 1 cell

[brumby]

Hiya folks,

Is it possible to return all hits from VLOOKUPS into a single cell, eg below :-


PART NUM SUFFIX
152191-2 XF
152191-2 XQ
152191-2 XQ
152191-2 XH
152191-2 XH
152191-2 XI
152191-2 XI
152191-2 XJ
152191-2 XJ
152191-2 XC
152191-2 XC
152191-2 XD
152191-2 XD
152191-2 XE
152191-2 XE
152191-2 XM
152191-2 XK
152191-2 XN
152191-2 OF
152191-2 OF
152191-2 OI
152191-2 OI
152191-2 EX

My Vlookup, looking for 152191-2 returns......XF, XQ, XQ, XH, XH, XI, XI, XJ, XJ, XC, XC, XD, XD, XE, XE, XM, XK, XN, OF, OF, OI, OI, EX

all within the same cell?

Is this at all possible?

Many Thanks