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

@Diana

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!

 

Andrée Starå

Hi DIana,

Do you need the VLOOKUP to include all 134 columns?

One way could be to consolidate the columns together with the JOIN function and then with the help of formulas break them out in another sheet. 

Would that work/help?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD