Hi all,

I'm using Excel 2010....I have the following formula in cell W3: =IFERROR(SEARCH("educ",G3),"NO")

As it is, it will search only cell G3 and return the answer. I need the formula to search cells G3 to S3 and return the answer if it finds the value being searched in any of those cells.

I tried the following but it does not work: =IFERROR(SEARCH("educ",G3:S3),"NO")


Can anyone help please?