title: Retrieving a specific cell value from Google app script sheet using JavaScript
body: <p>I'm trying to retrieve a specific value from a google app script sheet. I have a sheet where it stores information. I want to loop through that sheet based on row and retrieve all values that match and meet the conditions given.</p>
  
  <p>For example </p>
  
  <pre><code>if (row[4].toString().toLowerCase() == anotherRow[4]){
  
      //then display all rows which match that specific value
  
      // e.g:  
      row[4]. Display everything that matches anotherRow only;
  
  }
  </code></pre>
  
  <p>this is what I can't get my head around displaying all rows that meet that criteria only, currently I'm able to display all row[4], row[4] is the column </p>