Link limits regarding Vlookup

My question is regarding this statement:

"There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total."

If a cell on the inbound sheet is reading a range from another sheet, do all the cells in that range count against the inbound sheet, or is it just the one cell that is counted against the inbound sheet?

Scott

Find more posts tagged with

Manufacturing

Construction

Sheets

Formulas

Support

IT & Operations

Product Development

Cell linking

Comments

Daniel Stein

Hi Scott,

All of the cells that are being referenced in the source sheet range count against the limit. For example, if I am referencing a lookup table that has 5 columns and 100 rows, then that would be 500 referenced cells.

Re-using the same reference multiple times on the destination sheet does not count more than once, so you could reference the same 500-cell lookup table as many times as you want, and it would only count as 500 inbound cells.

Hope this helps,

Daniel

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.