Index Match inbounce limitation?

VincentW ✭✭
edited 06/16/22 in Formulas and Functions


As I known that Vlookup has a limitation that cannot reference more than 100,000 cells and cannot have more than 100 unique cross sheet references in one sheet.(

Question : I have a table with 7 columns(1 for identifier/6 for others) and 1,000 rows need to reference from master table(with same identifier).

What if I change formulas to [Index/Match] in those 6 columns, will it be limited by 100,000 cells rules as well?

thank you.


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Those limits are sheet based and not function based. The reason INDEX/MATCH will help though is that you only have to reference two columns instead of all 7.

    =INDEX({Column To Pull From}, MATCH("text", {Column To Match On}, 0))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!