Formula for more than 100 cross-sheet references?

Amy H.

I read that a sheet can include no more than 100 distinct cross-sheet references. I'd like to use INDEX/MATCH, but I have more than 100 matches. What are my options? How have others solved for this?

Paul Newcome

That limit is for {Cross Sheet References}. There is a much higher limit that I cannot remember off the top of my head for how many cells can be referenced. Your typical INDEX/MATCH only contains two unique cross sheet references which are what count towards the limit you are referring to.

Amy H.

Thanks, Paul! I should have clarified that I'm trying to use cross-sheet references in an INDEX/MATCH formula.

Amy H.

I learned from a colleague that "cross-sheet references" means something different from what I thought, and I am good.