title: Formulas Throw Invalid Reference
body: <p>I have a worksheet that has just over 1K rows on it, and I am wanting to get a list of what ID's exist in the second worksheet that holds roughly 600 rows.  I have tried using the <code>VLOOKUP()</code>, <code>IF()</code>, <code>COUNTIF()</code> functions, but each one gives me an error of</p>
  
  <blockquote>
    <p>Invalid reference.  <br>This file version can only have formulas that reference cells within a worksheet size of 256 columns (column IW or higher) or 65536 rows.</p>
  </blockquote>
  
  <p>What do I need to do so that I am able to compare these two lists?</p>
  
  <p>VLookup() I used = <code>=VLOOKUP(A3,[Book1]Sheet1!$A:$K,2,false)</code><br>
  CountIF() I used = <code>=COUNTIF([Book1]Sheet1!$A:$A,D1)</code></p>