Compare 2 columns and display result in 3 column also with part words

Hi. JLGWhiz
Just saw your last update. Not totally what i want. What i need to display in column E is the matches. Its because i need see if they are related to be sure. And the macro find part matches.
Example
N KOCH SKOLE Match
N KOCH SKOLE Match
KOCH SKOLE Match
KOCH KITCHENS " it will display KOCH KITCHENS because of the word KOCH but this is another company. So that i can fast see. So i need the matches to be displayed in column E and not the non matches-
But also now it dont find the matches with symbols as . , - and others. The 3 white now are matches but it dont find because of the dot.

Hope i explain it ok.
Sincerely
Abjac