There's a quiet frustration in the workaround that user BagConfident2457 describes, and it's one we recognize all too well. Manually swapping table references in a VLOOKUP because the data set changes feels productive for about ten minutes. Then it becomes exactly what they call it: busy work. The moment you're renaming Data20, you're not solving a problem, you're just maintaining a patch that shouldn't exist. And the fact that this is a common habit in spreadsheets everywhere says less about the users and more about how long we've accepted static formulas in a dynamic world.
The good news is that this isn't a limitation of the spreadsheet, it's a limitation of the approach. What they're asking for is straightforward: a lookup that knows which table to reference based on the value in a cell above it. That's not a radical ask. It's the kind of logical branching that any competent system should handle natively. The fact that it requires manual intervention, or a clever workaround involving INDIRECT, which we'd guess is where this is heading, is precisely the kind of friction that makes people antsy after the twentieth iteration. The tool should be doing the heavy lifting, not the user.
What's striking here is that the user isn't asking for a new feature or a plugin. They're asking for a better way to use what they already have. That's the sweet spot. When someone starts to feel the drag of repetitive edits, it's a signal that the workflow is the bottleneck, not their understanding of the tool. And that's where the opportunity lies: not in teaching people to be more careful with their formulas, but in giving them the confidence to build systems that adapt. The spreadsheet should feel like a collaborator, not a stubborn assistant that needs constant correction.
So here's the practical takeaway: if you're manually editing table references in your VLOOKUPs, stop treating that as normal. Start by asking whether the data can be structured to eliminate the need for switching altogether, sometimes a single, well-organized table beats five that look alike. If not, explore dynamic references that let a cell drive the lookup range. It's a small change in syntax, but a massive shift in how you think about your data. The goal isn't to avoid editing forever; it's to make every edit count toward something meaningful. And when you're no longer stuck renaming Data20, you'll wonder why you ever accepted that as part of the job.