Vlookup Limitation?

Vivien Chong
Vivien Chong ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi I would like to understand about this limitation in vlookup:

  • Each sheet can include no more thanΒ 100 distinct cross-sheet references.Β 
  • There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total.

(Reference:Β https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets?_ga=2.14620343.1874386604.1574040931-1620381183.1573536453)

Β 

What do you mean by 100 distinct cross-sheet references?

- If referencing to the same table, same criteria, is it consider 1 distinct cross-sheet reference?

Β 

Limit of 25,000 inbound cells?

- The destination sheet can only "receive" 25,000 inbound data?

- If we have 1 master sheet that will serve as database and need to be outbound to many sheets, can the outbound be more than 25,000 cells? Β Our master sheet contains 15 columns with 4000 rows.

Β 

We have start building a database where information can be pull out to other sheet to standardise the data input, we are at the end of the solution building when we realise this limitation. Β 

Appreciate advice and help in understanding this better.

Β 

Vivien Chong

Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd

Connect with us: 57network.com

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!