Search a range for specific word

Closed
Doug - Jul 23, 2009 at 01:42 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 23, 2009 at 10:48 PM
Hello, I need to search a range of cells for the word Yes and then retunr the word True or the number 1 in the formula cell.

Range: J2:U2
- Range contains either the word yes or it is an empty cell.

I have tried using the =IF(ISERROR(SEARCH("*Yes*",J2:U2,1)),"","True") and that did not work. It did not error, it just did not return anything. I have looked at the array formulas but have yet to find one that will work.

Any help would be greatly appreciated.

Thanks,
Doug

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 23, 2009 at 10:48 PM
Hello DOug

Try if(countif(Range,"=Yes")>0,"True","")
0