Comparing a tex cell with text column by countif formula

Hello!

I'm trying to solve a problem for about 3 hours now and while it seems trivial I really can't figure a way to do it.

I'm trying to compare a cell in Google Sheets against a column and I need to check if the text in cell match contains the text in column and then if there is a match, the cell should highlight.
I used the CountIf formula but it works only if there is an exact match.

The formula is in the second spreadsheet (Mid Tech Recruiter) in columne E.
What I need to achieve is that if in column D the text is eg. "Consdata spk" and in column A one of the cells is named "Consdata" then the formula will count.

Thanks for help!
Unfortunately it doesn't solve the problem, because if I write in column D eg. "Consdata X" it still doesn't count