I am a bit confused by the 25,000 cell reference limit. In my specific case I am simply trying to VLOOKUP from a table where I have 700 rows and 17 columns. That equals 11,900 cells which is less than 25,000 cells.
So, why am I getting this error? It creates an incredible amount of frustration and dissatisfaction with your product.