Play all

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

Description:

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.

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

ExcelIsFun

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Business Intelligence #DAX (Data Analysis Expressions) #Power Query #Data Science #Data Analysis #Spreadsheets #INDEX function #XLOOKUP

0:00 / 0:00