0

I have two very similar lines of code, one works exactly as expected (var terrIndex) one gives an unexpected result (var timeIndex)

LOG

function AdjAvail() {


var ss = SpreadsheetApp.getActiveSpreadsheet();
var masterSheet =ss.getSheetByName("Master");
var masterAvail = ss.getSheetByName("Unique Territories - Availability");
var transAvail = ss.getSheetByName("Uniques Territories - Transposed");

var apptTerr = masterSheet.getRange(6,2).getValue();
var apptTime = masterSheet.getRange(9,5).getValue();

var lastCol = masterAvail.getLastColumn();
var lastCol2 = transAvail.getLastColumn();
var lastRow = masterAvail.getLastRow();

var lookupTime = masterAvail.getRange(1,1,1,lastCol).getValues()[0];
var lookupTerr = transAvail.getRange(1,1,1,lastCol2).getValues()[0];

var timeIndex = lookupTime.indexOf(apptTime)+1;
var terrIndex = lookupTerr.indexOf(apptTerr)+1;
TheMaster
  • 37,620
  • 6
  • 43
  • 68
Smgrant4
  • 3
  • 2

0 Answers0