I wish to look up for a word of a phrase (written in a cell) in a column with
words.
e.g.

Col A Col B Col C
Col D
great hardware solutions 1 great 1
easy guides to success 0 benefits 1

I want to achieve the result in Col B (since 'great' is present in phrase of
A1 and 'great' is found in Col C too, the value corresponding to Col C in D
is 1 and thats what is achieved in Col B)

suppose I change Phrase in A1 to only 'hardware solutions'. Now since none
of the words of the phrase is present in col C, the value in Col B should
show 0.

thanks in advance for the solution