Yes/No formula in Excel

Yes/No formula in Excel


Hello I am just working in Excel with the same problem. I have 40K of rows in column A and would like to look up a word(s) and have a value "Yes" or "No" or even true or false. Does anyone know how to save me time doing this?


  • =IF(ISBLANK(RC[-1]),"", IF(OR( ISNUMBER(SEARCH("apple",RC[-1],1)), ISNUMBER(SEARCH("banana",RC[-1],1)), ISNUMBER(SEARCH("carrot",RC[-1],1)), ISNUMBER(SEARCH("donut",RC[-1],1)) ), "Yes","No"))


Solved by dameeti
Published by aakai1056. Latest update on August 31, 2010 at 11:59 AM by aakai1056.
This document, titled "Yes/No formula in Excel," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Office icons disappeared in Programs list
Outlook - View your message in your browser.