mardi 23 novembre 2021

Google Sheets App Script If Else not working

Test1 Sheet

enter image description here

Test2 Sheet

enter image description here

I want to compare News01 from Test1 A Column with Test2 A Column, and need to fetch the corresponding Test2 B column value

So the result should be Finance in Sheet1 B column

But If I use else, even when if statement is true it's going to else statement. If I delete else statement, then if statement is working.

I don't know why when if statement is true, it's going to else statement by default

function test() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var source_sheet = sheet.getSheetByName("Test1");
  var target_sheet = sheet.getSheetByName("Test2");
  var lastRow = source_sheet.getLastRow();
  var inputs = source_sheet.getRange('A' + lastRow).getValues().flat();
  var days = target_sheet.getRange('A1:A').getValues().flat();
  var codes = target_sheet.getRange('B1:B').getValues().flat();

  inputs.forEach(function(input, count){
    for(var i = 0; i < days.length; i++){
      if(days[i].trim() == input.trim()){
        source_sheet.getRange('B' + (count + source_sheet.getLastRow())).setValue(codes[i]);
        Logger.log(codes[i]);
        break;
      }
      else{
        Logger.log("News not found")
      }
    
    }
  });
}

Aucun commentaire:

Enregistrer un commentaire