LOOKUP Functions - Digital Feast

Lookups don’t have to be scary formulas buried in your spreadsheet. In this session, we’re turning VLOOKUPs, XLOOKUPs, and their clever cousins into everyday problem-solvers that save you time, reduce errors, and make your data work smarter. Whether you’re matching names to details, pulling prices from a master list, or consolidating information from different sheets, you’ll learn how to let Excel do the legwork for you.

This is about more than just typing in a formula – it’s about knowing when to use the right lookup, how to make them bulletproof, and how to combine them with other Excel tools for maximum impact.

On the menu:✅ How to use VLOOKUP and XLOOKUP to quickly find and return data from large tables✅ When to use INDEX + MATCH (and why it can be more flexible than VLOOKUP)✅ How to run lookups across multiple sheets and workbooks✅ Avoid common lookup mistakes that cause frustration and incorrect results

Lookups are a core Excel skill that unlock a whole new level of data power – and once you get the hang of them, you’ll wonder how you ever managed without them.

The Digital Feast sessions are interactive, with downloadable material, hands-on exercises, and live demos you can follow along with. I’ll be right there to mentor you, answer your questions, and show you the shortcuts that make Excel feel less like a maze and more like a toolkit. So grab a seat at the Digital Feast – it’s time to make your lookups work as hard as you do.