All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples
ExcelIsFun via YouTube
Overview
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