Vlookup with Multiple Answers in Lookup Cell!

Hello!

I have been struggling with this, and am hoping somebody out there can help! I have a massive spreadsheet with inspection failures. I am categorizing the failures into different types. Here is what I got:

"Data Sheet":

excel feb 23.jpg

"Criteria Sheet":

excel2 feb 23.jpg

As you can see, the vlookup is searching the reason for failure phrases on the data sheet and matching them to the criteria sheet. However, failures that have multiple reasons for failure are not showing up in failure types because vlookup doesn't know how to produce multiple results in a string of text. Can anyone help on how to list multiple vlookup results? I would prefer them to be listed all in the same cell with a comma separating them. I am also open to VBA if need be. Thank you!