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?
Bookmarks