How to check if keyword is in cell

Hi Guys,

I'm looking for a formula which can tell me if a keyword/text is contained in another cell.

For example:

screenshot.3879.jpg

I want to check if the keywords in column B is contained in column E (Title Tag)

Example in column C the keyword: pool house is contained in the title tag in column E, if this in column F it will be true (yes)

Cheers,

try the following formula:

Formula:

=IF(ISNUMBER(SEARCH(B2,E2)),"Yes","No")

if you need this to be case-sensitive, replace SEARCH with FIND