Find a text within range

[militambe3171]

I want to find a specific text in range, if that text is present in a range then output should be yes else no
[TABLE="width: 727"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]brands[/TD]
[TD]Keywords[/TD]
[TD]output should be[/TD]
[TD] Reason[/TD]
[/TR]
[TR]
[TD]Papermate[/TD]
[TD]Papermate pencil[/TD]
[TD]Yes[/TD]
[TD]coz it contains Papermate (Present in column A)[/TD]
[/TR]
[TR]
[TD]HP[/TD]
[TD]Papermate pen[/TD]
[TD]Yes[/TD]
[TD]coz it contains Papermate (Present in column A)[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]pencil[/TD]
[TD]NO[/TD]
[TD]Doesn’t contain any text from column A[/TD]
[/TR]
[TR]
[TD]Pental[/TD]
[TD]pen[/TD]
[TD]NO[/TD]
[TD]Doesn’t contain any text from column A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]highligher[/TD]
[TD]NO[/TD]
[TD]Doesn’t contain any text from column A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Brother abc[/TD]
[TD]Yes[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Hp printer[/TD]
[TD]yes[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]pepep- HP[/TD]
[TD]yes[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HP 240 xl[/TD]
[TD]yes[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

this is a sample data, want to do it for large data set

 

[Jonmo1]

Try

=IF(ISNA(LOOKUP(2^15,SEARCH($A$2:$A$5,B2))),"No","Yes")

Note, there cannot be any blanks in A2:A5

 

[Aladin Akyurek]

=ISNUMBER(LOOKUP(9.99999999999999E+307,SEARCH(" "&$A$2:$A$5&" "," "&$B2&" ")))+0

Custom format the formula cell as:

[=0]"No";[=1]"Yes"

 

[militambe3171]

Thank you Jonmo, It helped

 

[militambe3171]

Thank you Aladin