I have a master list of top keywords, and I want to search for variations of them in the remaining list of keywords.

Top Keyword List ------------ Remaining List
tall trees------------------------- fast blue cars
blue cars------------------------blue cars online
--------------------------------------trees grow tall
--------------------------------------grow tall trees
--------------------------------------blue cars rock
--------------------------------------really blue cars
--------------------------------------green tall trees

What I need is a formula that I can copy down next to the Remaining List, which checks if each of the values contains any of the substrings in the Top Keyword List, it can give a value of 1 or the substring etc

Maybe VBA is needed? Any help much appreciated..