title: Search if multiple substrings are present on a row
body: <p>So I've made the following code to search for an specific keyword on a row in a sheet:</p>
  <pre><code>function findNios() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var s = ss.getSheetByName('DataSheet');
    var r = s.getRange(2,11,s.getLastRow() - 1,1);
    var v = r.getValues();
    var searchTerm = &quot;nios&quot;;  
    const result = v.map(row =&gt; row[0].toString().toLowerCase().indexOf(searchTerm) &gt; 1 ? [&quot;Present&quot;]: [&quot;NO&quot;])
    r.offset(0,35).setValues(result)
  }
  </code></pre>
  <p>However this is only for one keyword in specific as defined here:</p>
  <p><code>var searchTerm = &quot;nios&quot;;  </code></p>
  <p>And now I want to add several terms to the search, so for example I have the following substrings that I want to search and if one isn't found proceed to look to the other term:</p>
  <p><code>var searchTerms = &quot;nios&quot;, &quot;blob&quot;: ,&quot;centre&quot;;  </code></p>
  <p>Is there a way to make this work with multiple terms?</p>