title: Excel Vlookup too Slow
body: <p>I have an Excel file that uses a <code>vlookup</code> on around 10000 rows, 8 <code>Vlookups</code> per row. Its ridiculously slow.</p>
  
  <p>It looks up another excel file located online - </p>
  
  <pre><code>=IF(ISERROR(VLOOKUP(E12,'Filepath.xlsx]Data'!$U:BV,54,0)),"None",VLOOKUP(E12,Filepath.xlsx]Data'!$U:BV,54,0))
  </code></pre>
  
  <p>I've looked around and vlookups seem to be pretty necessary. Are there possible structural changes which could make this go faster, such as vlookups on an SQL database?</p>
  
  <p>Thanks</p>