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
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
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
Related:
- Search a range for specific word
- How to search for a specific word on a webpage - Guide
- Word apk for pc - Download - Word processors
- How to search for a word in a pdf - Guide
- Number to text in word - Guide
- Google.us search - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 23, 2009 at 10:48 PM
Jul 23, 2009 at 10:48 PM
Hello DOug
Try if(countif(Range,"=Yes")>0,"True","")
Try if(countif(Range,"=Yes")>0,"True","")