Returning Multiple Data from VLookUp?

[druid9855]

I have this database with numerous different codes for the same listing:

All Fruit............Fruit Code
Apples..............AP1
Pears................PE1
Peaches............PC1
Bananas...........BA1
Pears...............PE3
Strawberries.....ST1
Apples.............AP3
Bananas...........BA4
Pears...............PE2

and want to set up a second sheet to give these results (the order of the codes and the delimiters does not matter):

Fruit.................Codes
Apples..............AP1, AP3
Pears................PE1, PE2, PE3
Peaches............PC1
Bananas...........BA1, BA4
Strawberries.....ST1

Can I do this with a VLookUp function or should I be using something else?

 

[sheetspread]

https://www.mrexcel.com/forum/excel...-all-matches-column-up-corresponding-row.html