javascript - Loop not working for column match -

i have loop work match row value bottom , goes this:-

var lastrow = s3.getlastrow(); var datarange = s3.getrange(1, 1,lastrow).getvalues(); for(var k=0;k<datarange.length;k++) {doing something} 

however, getting no result when trying same thing column match, here loop column match not anything.

var lastcolumn = s3.getlastcolumn(); var match2 = s3.getrange(1, 1,lastcolumn).getvalues(); (var b = 0; b < match2.length; b++)  {if (range[j][0] == match2[0][b]) { }  } 

please suggest missing.

this taken right out of documentation:

getrange(row, column, numrows)  range   returns range top left cell @ given coordinates, , given number of rows. 

match2.length number of rows in array or range.

this array [[x,x,x],[y,y,y],[z,z,z]...] has 3 x's in first row, 3 y's in second row , on. in s3.getrange(1, 1,lastcolumn).getvalues(); lastcolumn number of rows in range. it's easier read each row , column 1 @ time. or transpose data matrix , read columns rows.

a loop looking "big macs':

function myfunction()  {     var ss=spreadsheetapp.getactive();     var sh=ss.getactivesheet();     var rg=ss.getrange("a1:z1");     var va=rg.getvalues();     for(var i=0;i<va.length;i++)     {       for(j=0;j<va[0].length;j++)       {         if(va[i][j]=="big mac")         {           spreadsheetapp.getui().alert('do not eat burger has massive amounts of fat in it.');           break;         }       }     } } 

in these 2 dimensional arrays obtained commands such var data = range.getvalues(); data.length = number of rows , data[0].length = number of columns. total number of array elements data.length x data[0].length of may null. many programmers new google apps scripting have problems in area. in fact had lot of trouble ended doing work bolster understanding , can read here.

these arrays following: [[0,1,2,3,4,5...],[0,1,2,3,4,5...],[0,1,2,3,4,5...]...]. va array of arrays , term va.length equal number of elements in va , put it's equal number rows.