INDEX MATCH was long considered the pro alternative to VLOOKUP—but now we have XLOOKUP. So, which one should you use?
XLOOKUP is easier to write, easier to maintain, and comes with error-handling built in. But INDEX MATCH still has a few unique tricks—like two-dimensional lookups using MATCH twice.
This post breaks down performance, readability, and edge-case handling so you can confidently choose the right tool for each situation.
If you’re still using SUM and IF separately to crunch numbers in Excel, it’s time to level up. SUMIFS is one of Excel’s most powerful functions for analysing data — and it’s surprisingly eas...
Read More
Excel dashboards can be incredibly powerful — but let’s face it, not everyone is a designer. The good news? You don’t need a design degree to create dashboards that look clean, work beautifully,...
Read More
Power Query is one of Excel’s best-kept secrets — and if you’re not using it yet, you’re probably spending too much time cleaning, reshaping, or merging data manually.
Whether you're a beginn...
Read More
When it comes to working efficiently in Excel, keyboard shortcuts aren’t just time-savers — they’re game-changers.
As a trainer, I use dozens of shortcuts, but there are three that I rely on ev...
Read More
If you’ve been using Excel for years, you’ve probably tangled with VLOOKUP, wrestled with HLOOKUP, and maybe even constructed the occasional INDEX/MATCH combo when things got serious. But now, Mic...
Read More
