Need Help Retrieving Values from Columns

Hello,

I'm stuck in a bit of an problem and hoping someone could shine a light on this...The problem is I'm trying to figure out a method to find the value that matches in a column and if it matches the table then return that value in column B. The problem is that within a given row there could be multiple values that may match the values in the reference table so I would like to find a method that would return multiple values in a list format. I provided an example in a spreadsheet file and the goal I'm hoping to achieve as well, Any help would be greatly appreciated!

Thanks for any help!