Forum Discussion
Aaron_excel
Feb 26, 2020Copper Contributor
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?
5 Replies
Sort By
- PReaganBronze Contributor
- Aaron_excelCopper Contributor
Thank you so much! My google searches gave me everything but hard coding text. Saved my bacon!PReagan
- PReaganBronze Contributor