Compare rowA to rowB; list all matchs in adjacent row

Good day everyone,

I'm trying to compare a list of 150 items in a column to another column that may or may not have multiple items from the first column in it. If it finds a match it will print the match in the column directly to right of the same row; separated by a comma if possible. The second row or the row that is being compared to by the first row has a lot of data in it and will most likely have multiple items from the first column in them so my goal is to separate them out but in the adjacent column that the original data is found. I'm attaching a sample file and I would be grateful for any assistance. Thank you.

Hi JamesJohnson31,
maybe so

Please Login or Register  to view this content.

Thank you sir. This was just what I was looking for. My coworker was manualy separating the data and my efforts wern't getting the data to the adjacent cell. Thanks again.