I'm currently using the following formula for looking for certain text in a certain cell:

=IF(ISNUMBER(SEARCH("death",A1)),"yes","")

so if the cell has "death" it returns a "yes".

What I'm looking for is a this to look at a range of columns not just one cell.
ie A1:F1 and if any of the cells in this range I need the result to be "yes"

Any help would be appreciated.

Teeb