title: How to speed ​up the search data in sheet
body: <p>I have more than 1000000 record how to speed up search in sheet. I normally search for 20s how to improve ? (sheet include 20 column and 10000 record) </p>
  
  <pre><code>var ss =  SpreadsheetApp.openByUrl(urldb);
  var ws =  ss.getSheetByName("Account");
  var data = ws.getDataRange().getValues();
  
  for(var i = 0; i &lt; data .length; i++){
  
      if(data [i][1] == "ID998724"){
  
        Logger.log("found you" + data [i][1]);
  
      }
  };
  
  return data[i][1];
  </code></pre>