title: complex search of low and notify
body: <p>I have been asked to figure out how to perform a complex excel function. I'm new to this and am completely stumped :(</p>
  
  <p>I hope you can help.</p>
  
  <p>we have text data on 10,000 lines across 45 columns.</p>
  
  <p>So as an example, in N1 I need a function that looks for words in all cells across row 1.</p>
  
  <p>So if i was to search for "apple" and "pear" and "orange" and "banana", If one or more were found on row 1 then in cell N1 I would like to output "banana, apple" if it found those two words. If nothing was found then it says none.</p>
  
  <p>I've been told this isn't possible but i'm not so sure.</p>
  
  <p>Sorry for the long explanation.</p>
  
  <p>Hope you can assist.</p>
  
  <p>Thanks </p>