function findInColumn(column, data) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var column = sheet.getRange(column + ':' + column); // like A:A

  var values = column.getValues();
  var row = 0;

  while (values[row] && values[row][0] !== data) {
    row++;
  }

  if (values[row][0] === data) return row + 1;
  else return -1;
}

function findInRow(data) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var rows = sheet.getDataRange.getValues();

  for (var r = 0; r < rows.length; r++) {
    if (rows[r].join('#').indexOf(data) !== -1) {
      return r + 1;
    }
  }

  return -1;
}