title: Google Sheet script getValues and when find the given value, replace the value of the above row
body: <p>How can I modify the script below to read the values in a column, but only read the values of the specified cells: L9, L10 ... L18, L19 .... L27, L28 .... (two by two jumping eight, to the end of the column L2000) and when find the value "1" in one of those cells, then replace the value that is 4 lines up with "FALSE"?</p>
  
  <p>e.g. if cell L19 is found the number 1, then replace the value of cell L15 with the word "FALSE" ... and if cell L28 is found the number 1, then replace the value of cell L24 with the word "FALSE"</p>
  
  <pre><code>var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("ABC"); 
  var lastrow = ss.getLastRow(); 
  var range = ss.getRange(9, 12, lastrow - 1, 1); 
  var data = range.getValues(); 
  for (var i=0; i &lt; data.length; i++) { 
    if (data[i][0] == "1") { 
      data[i][0] = "FALSE"; 
    } 
  } 
  range.setValues(data); 
  </code></pre>