Index Match inbounce limitation?

VincentW

Hi,

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.(https://community.smartsheet.com/discussion/68137/vlookups-in-smartsheet-are-there-limitations)

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.

Paul Newcome

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))

Paul Newcome

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))

VincentW

Hi Paul,

Thanks for your reply! That's helpful!

Paul Newcome

Happy to help. 👍️