Index Match inbounce limitation?
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?
Help Article Resources
Check out the Formula Handbook template!