There's a quiet frustration buried in that Reddit post, and it's one we've all felt at some point: staring at a table, copying values by hand, and wondering why the tool we're using can't just do the obvious thing. The user's request is simple. They have a table, they have a value, and they want Excel to automatically fetch the corresponding result instead of forcing them to type it out. That's not a niche ask. That's the bare minimum of what a spreadsheet should do. And yet, the fact that this person is asking for help, rather than assuming the capability exists, tells you everything about how far the default experience has drifted from common sense.
The screenshots they shared show a classic lookup scenario, likely a VLOOKUP or INDEX/MATCH situation, but the fact that they're manually entering values suggests the barrier isn't the formula itself. It's knowing that the formula exists, and then having the confidence to build it correctly. That's where the spreadsheet industry has quietly failed its users. We've accepted a status quo where the person with the most domain knowledge is also expected to be a database engineer. The tools assume you'll learn their logic, not that they'll adapt to yours. So when someone asks "how do I stop typing values by hand," the real question is: why is that even a question in 2025?
What's striking is how close the solution is. The data is already structured. The relationship is already there. The user just needs a bridge between the visible table and the cell where the answer should live. That bridge exists, and it's not complicated. But the fact that it feels like a breakthrough to discover it, rather than a default expectation, is the problem. We're not talking about advanced machine learning or predictive modeling. We're talking about a basic lookup, a task that should be as intuitive as dragging a formula down a column. The fact that it isn't, and that people are still manually transcribing values, points to a deeper gap between what spreadsheets promise and what they deliver out of the box.
The takeaway here isn't that Excel is broken. It's that the moment you stop treating spreadsheets as static grids and start seeing them as relational systems, everything changes. That user doesn't need to learn a new app or abandon their workflow. They need one formula, applied correctly, to turn a repetitive chore into an automated process. That's the shift worth making, and it's available right now, in the tool they already have. The next time you catch yourself typing a value that already exists somewhere else in the workbook, stop. Ask the question they asked. Then go find the function that answers it. The answer is already there, waiting in the table.