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

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

ExcelIsFun via YouTube Direct link

1. Introduction

1 of 36

1 of 36

1. Introduction

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

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.