I am having a hard time figuring out this What-If formula. I have my employees make notes in Cell A. So A1 might read "The customer came into the store wearing a red hoody" and cell A2 might read "The customer came in with a backpack." I am trying to have the spreadsheet "flag" the cell that contains the word "hoody" or "Backpack." My problem is this.. when I do =if(A1="hoody", "Yes", "no") the result always comes back as no because there are more words in the cell. Has anyone found a work around that would filter out the word "hoody" within that cell?
I'm sure its pretty close to what you would like. The original Poster was searching for two particular words (sentences in Column J) returning the result in Column A where the formula has been dragged down. You probably get the drift of the formula so just change the words and cell references to suit yourself and add a couple of more arguments for the additional two words you wish to find.