问如何在Google工作表中检查一个值与另一个值，然后查询具有匹配值的单元格的属性？

EN

var i = 0;

// Bringing in the data from the third-party into Google Sheets.
var groupJSON = UrlFetchApp.fetch('<ANY-JSON-URL>');
var groupObjectRaw = JSON.parse(groupJSON);
//  var groupObject = groupObjectRaw[0]; <--optional, for my use only

var membersGroupForm = groupObject.data['member'];
var projectsGroupForm = groupObject.data['project'];
var hoursGroupForm = groupObject.data['hours worked'];

var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Details');

var membersRange = ss.getRange('Details!A:A');
var membersSheet = membersRange.getValues();

var projectsRange = ss.getRange('Details!1:1');
var projectsSheet = projectsRange.getValues();

function getRowNumber() {
  for (i; i < membersSheet.length; i++) {
    if (membersSheet[i][0] == membersGroupForm) {
      return i + 1;
    }
  }
}

var rowNumber = getRowNumber(i, membersSheet, membersGroupForm);
Logger.log(rowNumber);

function getColumnNumber() {
  for (var row in projectsSheet) {
    for (var col in projectsSheet[row]) {
      if (projectsSheet[row][col] == projectsGroupForm) {
        return parseInt(col) + 1;
      }
    }
  }
}

var columnNumber = getColumnNumber(projectsSheet, projectsGroupForm);
Logger.log(columnNumber);

var cell = ss.getRange(rowNumber, columnNumber);
cell.setValue(hoursGroupForm);