title: Get cell value by row and column number using google script
body: <p>I have created a function that returns the row indexes which contain the information I am interested in, as below:</p>
  
  <pre><code>[0.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.0, 13.0, 14.0, 15.0, 16.0, 17.0, 18.0, 19.0, 20.0, 21.0, 22.0]
  </code></pre>
  
  <p>I know want to store cell values from certain columns (say Column P row 2) in a list but I cant work out how to use the array above to get values from a cell. </p>
  
  <p>My current code is:</p>
  
  <pre><code>for (var y = 0; y &lt; ListOfContact.length; y++) {
     if(ListOfContact[y] == "Wait"){
        ListOfRowNumbers.push(y);
     }
  }
  
  Logger.log(ListOfRowNumbers);
  
  var listOfRelevantCells = [];
  
  for (var yy = 0; yy &lt; ListOfRowNumbers.length; yy++) {
  //need to push the cell values to listOfRelevantCells
  
  }
  </code></pre>
  
  <p>I simply can't find the function to do this but I am sure it is obvious!</p>