If cell contains a specific word, then write another word in another cell

[Delph]

Hi,

I'm trying to use the functiun =IF(ISNUMBER(SEARCH but it does not seem to work. For example, B1=ho hu hi, B2= hi hi hi, B3= hu ho hu, and i want to write "ok" in A1 if B1 contains "ho". So in A1 I write =IF(ISNUMBER(SEARCH("ho",B1)),"ok","") but il tells me my formula contains an error, where am I wrong ?

Thanks

[NeedForExcel]

=IF(ISNUMBER(SEARCH("Ho",B1)),"OK","") This works for me.. Should work for you too..

Please attach you workbook if possible.

Deep

[Delph]

By the way, i'm using a new computer, I don't know if I have to activate something, i'm quite new at Excel.

[NeedForExcel]

Please see the file attached.

[L-Drr]

Maybe it's semantics or syntax? Are you translating from Dutch or French?
For Dutch translations, mind the difference between VIND.ALLES and VIND.SPEC and using semicolon (;) or comma (,) between arguments.

[Delph]

Thanksss it works, don't know what was wrong.

[NeedForExcel]

Glad it helps..

Deep