Search row for an entry

[ytmnd85]

Hello all,
I am working with a large spreadsheet, and I'd like to identify which rows contain certain entries, and I've been having quite a time figuring out the correct formula to use.

On my data sheet, each row constitutes a gene of interest. There are also several cells in each row that give annotations for this gene (Ex: A2 gives the title of the gene, and C2, D2, E2, and F2 each give different annotations of the gene). What I'd like to do is identify which genes have a specific word in at least one of their annotations. Ex: I'd like to search C2, D2, E2 and F2 for the word 'defense', and if any of these cells contain the word 'defense', then I'd like for G2 (an empty cell) to display a notification, like 'yes'.

Does anyone have suggestions for what formula I could use?

Thanks

[StephenR]

Here is a suggestion:

=IF(COUNTIF(C2:F2,"*defence*")>0,"Yes","No")