Jul 23, 2009 at 01:42 PM
Posts261Registration dateSaturday April 11, 2009StatusMemberLast seenJune 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 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.