I am looking to compare a dynamic range of bank transactions against a list of keywords split into categories. The transaction cells have a long string of multiple words, and am looking to find with cells that contain any of the keywords in each of the categories. I have tried to look at it both ways, comparing the transactions to the keywords or comparing the keywords to the transactions.

Sheet 1
Wells Fargo Snip-It.PNG

Sheet 2
Categories Snip-It.PNG

If a cell in Sheet 1 Column C contains a keyword from Sheet 2 Column A, then I'm looking to paste the Header of each range in Sheet 2 into the corresponding row of Sheet 1 Column D.

Thank you for any insight into this problem.

Jeff