Look up and Retunn 2 lots of data in the same cell

hello all

Please see attached
Scrap Tab – K6 = i need a formula to look up Part number in A and return the pallet from the VMS tab
Currently using VLOOKUP however this finds 1 lot of data, sometimes there can be 2 or 3 lots different pallet numbers as highlighted in yellowon the VMS tab

Expected results highlighted in yellow in K6 – So the formula will advise me what pallet numbers the part numbers appear on


Paul