Forum Discussion

Aaron_excel's avatar
Aaron_excel
Copper Contributor
Feb 26, 2020
Solved

searching a sheet with a true and false function

Hello, I am trying to search a column to give me a true or false value in the column next to it. I do not know how to write the formula I need. I would like to search column B row 2 through 10. If the cell contains the word 'pencil' and excludes the words 'case', 'grip', 'sharpener', and 'mechanical' I would like the corresponding cell in column C to read TRUE. Is there a formula I could use for this? 

Resources