Power Bi Formula for (Cell contains multiple formulas in Excel)

[keboon]

Hi All:

I am trying in to write a formula so that the formula 1st looks at the Keyword Column, see the keyword then searches the Search Query Column and if it contains keywords found in the Keyword Column then the output will be "Keyword Found".   Any help would be appreciated.

[keboon]

I have one more question that is relevent to the revious answer.

Suppose the words in the search query match the keywords but the words are in a different order and have extra words in it.  Is there a formula that can find the different order of words and still count as a keyword found for the results?  Screenshot below of the problem.

[Vijay_A_Verma · Accepted solution]

You can use below formula

Result = IF(ISNUMBER(SEARCH('Table'[Keyword],'Table'[Search Query],,BLANK())),"Keyword Found")