Searching out Phrases in What-If Scenarios Closed

Question

Hello, 
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? 

Configuration: Windows 7 / Mozilla 11.0

ac3mark · Answer

Try the FIND function? 

I think SEARCH will do it!
It's kind of fun to do the impossible! -Walter Elias Disney

vcoolio · Answer

Hello Tylernicoll,

Have a look at the following link:-

https://www.dropbox.com/s/wfbrnz5jjpp3uha/EST.xlsx?dl=0

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.

I hope that this helps.
Cheerio,
vcoolio.

Searching out Phrases in What-If Scenarios

2 responses

Similar discussions

Subscribe To Our Newsletter!