Excel users can skip formulas and let AI merge reports in seconds.

Are you feeling frustrated with complex Excel functions like XLOOKUP?

3 min readMicrosoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

The moment a program tech shows a room full of people how to merge two Excel reports using Copilot instead of XLOOKUP, something important just happened. It wasn't a failure of skill or a shortcut taken by someone too lazy to learn the "right" way. It was a quiet signal that the rules of spreadsheet work have changed, and most of us haven't caught up yet.

Here's the thing we need to sit with: the goal was never to know XLOOKUP. The goal was to get two reports merged accurately and quickly. That tech did that. She didn't need to memorize syntax or debug a formula that returned `#N/A` for the third time that morning. She asked the tool to do the job, and it did. If your first reaction is frustration that she didn't suffer through the same learning curve you did, you're not protecting standards. You're protecting a status quo that's already obsolete.

What this means for you, the person who lives in spreadsheets daily, is more practical than philosophical. It means the barrier to entry just dropped for everyone. The colleague who used to avoid touching your shared workbook can now contribute meaningfully without a week of training. The report that used to take you twenty minutes of careful formula writing might take them two minutes of plain-language prompts. That's not a threat to your expertise. It's a reminder that your value isn't in knowing the keystrokes. It's in knowing what the data means, which questions to ask, and how to act on the answer. The tool handles the plumbing. You handle the judgment.

So instead of putting your head through your desk, consider what that demo just revealed. If a program tech can merge reports without knowing XLOOKUP, then the skills that used to separate the spreadsheet elite from everyone else are no longer the gatekeepers they once were. That's a good thing. It frees you up to focus on the work that actually matters: interpreting results, spotting anomalies, and making decisions. The next time you feel that flash of irritation when someone skips the formula and goes straight to the AI, pause. Ask yourself what you're really defending. If it's the craft, fine. But if it's just the comfort of knowing something they don't, you're on the wrong side of progress. The spreadsheet isn't the product. The insight is. And that tech just got hers faster than you did.

From Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

A program tech at work just gave a demo on how to have copilot merge two excel reports because she didn't know how to use the xlookup function. I want to put my head through my desk.

Read the original at Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community