Dear Forum.
I am trying to find a formula that is checking various cells for specific text. The solutions I've seen (ISNUMBER or COUNTIF) only show the formulas for if the cells that you are checking are adjacent (e.g. A12:A26). However in my case the cells that I'm looking to check are not next to each other.
For the example of the screen shot below… I’m looking for a formula for cell E5. That formula would look in cells A10,A11,C10,C11,F10,F11 for the word “Paint”. If the word “Paint does exist in any of those ceils then I want the word “Yes” to be shown in cell E5.
Thank you.
ExcelContainTextScreen.jpg
Bookmarks