Match specific words in cell and return value if true or false

**jbrooksia** · 03-27-2012, 03:52 PM

I need a formula that will identify 3 word in a cell that are separated among other words to return a specific value.

Example: The quick brown fox jumps over the lazy dog.

I need a formula that will find quick, fox and over and return the text value "Oh my gosh!"

I have tried if( count (search and can get it to find quick, fox and over, but some cells will have just quick and other fox and over, so I am getting positive returns on any cell that contains any one, two, or three of those words.

I need it to return only the cells that contain all 3 of those words.

**daddylonglegs** · 03-27-2012, 04:04 PM

Well, if all 3 are there the count will be 3 so try

=IF(COUNT(SEARCH({"quick","fox","over"},A1))=3,"Oh my gosh!","D'oh!")

**jbrooksia** · 03-27-2012, 04:09 PM

DOH! Thank you!!!!

**Paul** · 03-27-2012, 04:15 PM

Hi JBrooksia, welcome to the forum.

I've adjusted your thread title to something that is actually descriptive of your issue, per forum rule #1. Please take a moment to read them (link in my signature) and in the future create similarly descriptive titles.

Thanks!