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

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

Find more posts tagged with

Sheets

Formulas

Support

Solution Center

Conditional Formatting

Cell linking

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.