Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples

ExcelIsFun via YouTube

Overview

Dive into an extensive video tutorial on essential Excel lookup formulas, covering Excel Worksheet, Power Query, and DAX with 28 practical examples. Learn from Excel MVP and Highline College Professor Mike Girvin as he guides you through a comprehensive range of lookup techniques. Master functions like XLOOKUP, XMATCH, INDEX, FILTER, and SWITCH, and explore advanced concepts such as two-way lookups, wild card lookups, and approximate match lookups. Gain hands-on experience with Power Query and DAX for exact and approximate match lookups. Download accompanying Excel files and PDF notes to enhance your learning experience. Perfect for Excel users looking to elevate their data analysis and manipulation skills.

Syllabus

1. Introduction
2. XLOOKUP function
3. Exact Match Lookup
4. Data Validation List
5. Lookup a Record
6. Lookup a Column
7. Exact Match or Next Smaller Lookup Approximate Match Lookup
8. Vertical or Horizontal Lookup?
9. Lower Limit for Exact Match or Next Smaller Lookup
10. Exact Match or Next Bigger Lookup
11. Wild Card Lookup
12. Lookup First Item
13. Lookup Last Item
14. Lookup last sale made with MAXIFS function
15. Two-Way Lookup
16. Two Lookup Values
17. Lookup a Range of Values with a Specified Start and End Value
18. FILTER function
19. Single Lookup Value, Return Multiple Matches
20. XMATCH function
21. Compare Two Lists
22. INDEX function
23. Random Lookup: single value and a complete column
24. LOOKUP function
25. Vertical and Horizontal Lookup?
26. Tax Example where LOOKUP beats XLOOKUP
27. SWITCH function to Lookup a Table
28. XLOOKUP Spilled Exact Match Lookup
29. XLOOKUP Table Exact Match Lookup
30. Power Query: Exact Match Lookup
31. Data Model DAX: Exact Match Lookup
32. Concept for Approximate Match Lookup in DAX & M Code formulas
33. Data Model DAX: Approximate Match Lookup
34. Power Query: Approximate Match Lookup
35. Summary and Conclusions
36. Closing and Video Links

Taught by

ExcelIsFun

Reviews

Start your review of All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.