Check for a word

[kashyap]

I was try on a formula something like, if 1 of the words in b10=d10 then it should give output as 1 in E10

 

[njimack]

Formula in E10: =IF(ISNUMBER(SEARCH(D10,B10)),1,"")

 

[Willem!]

In E10:

=IF(ISERROR(FIND(D10,B10,1)),0,1)

When the word in D10 is in B10, then the value in E10=1. If it's not E10=0.

Is this the output you seek?

 

[kashyap]

Thanks both of you..

I tried implimenting this for a range.. But..

That is Say I have words list from H1:H25 and sentences from B1:B200

Now, in ColC (C1:C200) I need a formula which will search for a word (which is in H1:H25) in B1:B200 and enter that particular word.