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