Essential Formulas: VLOOKUP, IF, and the Functions That Matter

About half the messy spreadsheets people send to consultants could be fixed with just two ideas: “find this” and “if this, then that.” A sales report, a budget, a hiring plan—very different files, all secretly powered by the same tiny formulas you probably underuse.

“VLOOKUP is the most popular function in Excel—and the most mis‑used.” That’s from Microsoft’s own support data, and it shows up in a very specific way: people think the formula is “broken” when it’s actually doing exactly what they (accidentally) asked for. Around 15% of lookup errors trace back to a single default setting: approximate match left on when you needed an exact one.

So in this episode, we’re not just learning formulas—we’re debugging how you *think* about them. We’ll look at why VLOOKUP and IF sit at the center of real-world models: pricing tables that update across thousands of SKUs, headcount plans that shift when one assumption changes, finance models where a single mistyped range quietly corrupts a quarter’s forecast.