Sunday, November 9, 2014

yogi_Formula In Cell A4 To Check Whether Any Or All Of Entries In A1 To A3 Occur In String B4

                 Google Spreadsheet   Post  #1827
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Nov-09-2014
post by  Mike Taus:
Combining IF Search functions in Google Sheets
I'm trying to setup an IF function that looks for certain words in a field and then returns that word. My function looks like this and works if I have a single word like this:

=IF(search("apple", B2),"apple")

But if I try to add another word search like this it fails:

=IF(search("apple", B2),"apple"),IF(search("banana", B2),"banana")

I'd like to be able to combine several word searches and return that word, plus "none" if none of the words is found.

Thanks in advance

Here's a link to a test sheet.
The first 3 cells illustrate how I would like to search for a text string and if it is found display in the cell.  I'm trying to figure out how to combine those 3 formulas into one. The 4th cell should contain 'none'.

Thank you for your help.