Look left when your value moves between rows. That was the problem, and the solution was a formula. It shouldn't have required a Reddit post, yet here we are. The user who submitted this question spent time wrestling with XLOOKUP and IF statements, only to discover that the tool they were using simply wasn't built for the task. That's not a skill gap. That's a design gap.
Traditional spreadsheets assume your data stays in neat, predictable columns. When it doesn't, when the value you need appears in a different column on every row, the formulas become contortions. XLOOKUP works great for vertical lookups. It fails when the lookup value moves horizontally across a row. IF statements can be stacked, but they turn brittle and unreadable, especially across 3,500 rows. The user's gratitude at the end, "THANK YOU SO MUCH!! IT worked", isn't just relief. It's the sound of someone who just realized they were fighting the wrong tool.
What this means for you is practical. If your data regularly shifts position row by row, you're spending time writing workarounds instead of reading results. The formula that solved this user's problem likely combined INDEX and MATCH in a way that adapts to each row's structure. It's a smart solution, but it's also a symptom. Smart workarounds are what you build when your spreadsheet doesn't understand your data. AI-native tools, by contrast, can infer where values live and retrieve them without you specifying the exact column. They treat each row as its own context, not as a rigid grid.
We think the real takeaway is simpler than a formula. You shouldn't have to ask the internet how to look left. The tool should handle that. The user's question reveals a broader truth: most spreadsheet problems aren't actually about formulas. They're about the tool forcing you to think in columns when your data thinks in rows. The solution isn't a better workaround. It's a better foundation. Start there, and looking left won't feel like a puzzle.