This is the kind of problem that perfectly illustrates the gap between what spreadsheets can do and what they should do. The user on Reddit has a straightforward need: count exceptions across documents and summarize them in a clean table. That should be a simple ask. Instead, they are wrestling with INDEX and MATCH, searching forums, and hoping a formula exists that will save them from manual work. We have all been there, and the frustration is familiar. The real issue is not the user's skill. It is that traditional spreadsheets force you to become a part-time programmer just to complete a basic aggregation task.
The user's data lives on one sheet: each row is a document number paired with an exception type. They want a summary table showing, for each document, how many policy deviations and how many pricing deviations occurred. In a modern AI-native spreadsheet, this is a single prompt. You describe the table you want, the tool reads the source data, and the summary appears. No formula debugging. No cross-sheet lookups. No wasted time. The user's current approach is a workaround, not a workflow. It assumes the tool cannot understand relationships between data, so the human must manually encode every logic step.
What this story tells us is that the spreadsheet industry has trained users to accept complexity as a given. When someone asks "How would you approach this?" about a simple count, it signals that the tool has failed its primary purpose: making data work for people, not the other way around. An AI-native spreadsheet should see the connection between documents and exceptions instantly. It should ask clarifying questions if needed, then produce the output without demanding the user memorize array formulas. The fact that this user is a self-described "Excel expert" and still hit a wall shows the ceiling of legacy tools.
The practical takeaway is direct: if you are spending time on forum posts trying to make INDEX and MATCH behave, you are not the problem. The tool is. The next generation of spreadsheets will not require you to translate your thinking into formula syntax. You will describe what you need, and the spreadsheet will build the structure for you. That is not a distant vision. It is available now. The user in this story deserves a tool that respects their time. We think they should stop searching for the right formula and start exploring a solution that handles the logic so they can focus on the exceptions themselves.