Find row number by value

findRowByValue.gs

function findRowByValue(sheet, value) {
  var dataRange = sheet.getDataRange();
  var values = dataRange.getValues();

  for (var i = 0; i < values.length; i++) {
    for (var j = 0; j < values[i].length; j++) {     
      if (values[i][j] == value) {
        //Logger.log(i);
        return i+1;
      }
    }    
   }
  return -1;
}