title: Google apps script - Get row number of a cell containing specific value
body: <p>How could I get the row number of a cell which contains a specified value.</p>
  
  <p>In the code below I would like to get the row number of the cell containing number 5 in the column H.</p>
  
  <pre><code>function doGet(e){
  
     var spreadsheet = SpreadsheetApp.openById("........sheet id........");
     var sheet = spreadsheet.getSheetByName("Sheet1");  
  
  
    var containingValue = 5;
    var range = sheet.getRange("H1:H"); 
  
  
   // [code to get valuie of Row]
  
  
    sheet.getRange(Row, 12).setValue("A text");
  }
  </code></pre>
  
  <p>I would like to get the value of the row and update another cell in that row.</p>
  
  <p>Please help. Thank you.</p>