Searching words in sentences

[inspectoRQ]

have a nice day all!

is possible finding word in column? i.e

a1 b1 c1

book the books is on the table. ?

i wanna use like this. if b1 contains a1 then c1= ok?

 

[anandvarma]

can you give examples of data you are looking for

 

[Ruddles]

Something like this:-

=IF(ISERROR(FIND(A1,B1)),"no","ok")

That's case-sensitive. For a non-case-sensitive match, try;-

=IF(ISERROR(FIND(LOWER(A1),LOWER(B1))),"no","ok")

 

[VoG]

Try in C1

=IF(ISNUMBER(FIND(A1,B1)),"OK","-")

 

[inspectoRQ]

Thanks o lot all. works suppa.