Comparing strings and counting instances in a complex datasheet

Hi all -

I'm am struggling with a datasheet with less than ideal data. I cannot share the sheet, as the data is proprietary, so I will do my best to explain:

Worksheet "Report" has string data (descriptions) in Columns K:O. A portion of the string will have a keyword. There is no rhyme or reason to how the string will appear (meaning it doesn't begin in a predictable way, it's just potentially there in the cell. Some cells are blank). Once the keyword has been found in any cell in the given row, the count should return a 1 and then move on to the next row. For example:

In Row 2, Column K has the string "Steel Connector" and Column M has the string "Steel Plating Connector". I need the code to find the first instance of "Connector", return a 1 for counting purposes and then move to row 3.

To add to the pain, the keywords list on which I'm searching is over 75 words long. I have them on a separate sheet (Metrics) in Column A. So I'd like to use a comparative of some kind instead of hard coding in the keywords.

It's late and I'm fried, so I just can't come up with the right way to do this. Plus my VB skills are old and I'm at a new job, trying to get this right. I hope someone can help! Thank you!