There's a Reddit post making the rounds, a user asking whether INDEX and MATCH is the right formula to pull an Assignment type into column B. They can get it to pull, just not correctly. That single sentence captures the experience of millions: close enough to frustrate, far enough from working to waste an afternoon. And our take is plain: you shouldn't have to wrestle with formulas to move data between columns. The fact that this user is skilled enough to know INDEX and MATCH exists, yet still can't get the result they want, tells you everything about the gap between what spreadsheets demand and what people actually need.
What this means in practical terms is that the traditional spreadsheet model, where every cell expects you to write a precise incantation, has become a bottleneck. The user isn't asking for something exotic. They want to map one column of data to another. That's a basic data relationship, not a financial model or a statistical analysis. Yet the tool requires them to troubleshoot syntax, debug cell references, and guess whether they've misaligned their ranges. The time spent on that single lookup could have been spent analyzing the Assignment types themselves, or acting on the data instead of chasing it. This isn't a skill issue; it's a tool issue.
The real opportunity here is to stop treating formulas as the only path to answers. AI-native spreadsheets can understand intent. Instead of asking "Is INDEX and MATCH the right formula?" a user should be able to say "Show me the Assignment type next to each student's name" and have the system infer the relationship, handle the join, and deliver the result. That isn't science fiction, it's what happens when you build a spreadsheet that understands columns as structured data, not as arbitrary grids of text and numbers. The user's frustration is a signal that the old paradigm is holding them back, not enabling them.
So here's the concrete point: if you've ever spent more than five minutes debugging a lookup formula, you've already proven that the tool needs to change. The next spreadsheet you use should let you describe what you want, not dictate how to compute it. That's the shift worth exploring, not a better version of INDEX and MATCH, but a way to pull your data without wrestling for the right syntax.