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 VLOOKUP(), IF(), COUNTIF() functions, but each one gives me an error of
Invalid reference.
This file version can only have formulas that reference cells within a worksheet size of 256 columns (column IW or higher) or 65536 rows.
What do I need to do so that I am able to compare these two lists?
VLookup() I used = =VLOOKUP(A3,[Book1]Sheet1!$A:$K,2,false)
CountIF() I used = =COUNTIF([Book1]Sheet1!$A:$A,D1)
As discussed in comments, the thing with recent versions is about formulas working on a compatibility mode. Having more/less rows available brings up these kind of errors.
Are you working in excel 2013 with a .xls file? If you switch to work in a .xlsx file it might just work.