javascript - 询问如何在另一张纸上找到对应的值并打印结果

Question

function myFunction() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
        
// VLOOKUP target
   var targetSheetValues = ss.getSheetByName('target');
   var inRow = 3;
   var keyColumn = 6++;
   var valueColumn = 2;
   var inData = sheet3.getRange(inRow, keyColumn, sheet3.getLastRow(), valueColumn).getValues();
   var inDic = {};
   
   // key, value array save
   for(var i = 0; i < inData.length; i++) {
     inDic[inData[i][keyColumn-1]] =inData[i][valueColumn-1];
   }
   
   // input setup
   var sheet2 = ss.getSheetByName('input');
   var startRow = 2;
   var targetColumn = 1;
   var setColumn = 3;
   var lastRow = input.getLastRow();
   var targetValue;
   var setValue;
                                                   
   for(startRow ; startRow <= lastRow; startRow++){
                                                           
   targetValue = input.getRange(startRow,targetColumn).getValue();
   setValue = inDic[targetValue];                                 
   input.getRange(startRow,setColumn).setValue(setValue);         
   }

  
  var d = new Date(); 
  var sheet = SpreadsheetApp.getActiveSheet(); 
  var range = sheet.getRange("B2:C2");

  range.setValue(d);   

}

我想在'目标工作表'中找到与'目标日期'匹配的日期，并将多个范围的值加载到'当前工作表'中。我写了一个类似于 vlookup 的脚本，但我需要帮助，因为很难找到原始解决方案。

标签： javascriptgoogle-apps-scriptgoogle-sheets