Help! Already reached Vlookups Max reference Cell count of 25,000

@Diana
@Diana ✭✭
edited 12/09/19 in Formulas and Functions

I need a solution to the vlookup max reference cell count of 25,000.

I have a database that zapier loads data too from an application. The database consists of 134 columns, and will grow to an estimated 300+ row count. Which works out to 39900 cells, which is 14,900 cells over the limit.

I use a summary sheet to gather data using vlookup, and create dashboards from this data. Is there a better formula to use that doesn't have a cell limit and will return the same function as vlookup?

help!

 

Screen Shot 2019-08-29 at 9.57.23 AM.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!