Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples

ExcelIsFun via YouTube Direct link

) Introduction

1 of 29

1 of 29

) Introduction

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction
  2. 2 ) Exact Match is XLOOKUP Default
  3. 3 ) 3 arguments for Exact Match, one fewer than VLOOKUP
  4. 4 ) Can insert Columns and it still works!!!!!
  5. 5 ) Approximate Match using Exact Match , previous smallest, match_mode argument set to -1. See example of LOOKUP function (old function) that may be more efficient than newer XLOOKUP.
  6. 6 ) Approximate Match & You Don't Have To Sort!!!!!
  7. 7 ) Approximate Match using Exact Match , previous biggest, match_mode argument set to 1
  8. 8 ) Also see XLOOKUP as Spilled Array. Also see SORT & UNIQUE Functions.
  9. 9 ) Find First Values, Amongst Duplicates
  10. 10 ) Important Lesson about Dimensions of lookup_array and return_array.
  11. 11 ) Horizonal or Vertical Lookup, or Both. More important lessons about dimension sizes of lookup_array and return_array.
  12. 12 ) See example of VLOOKUP & MATCH functions (old functions) that may be more efficient than newer XLOOKUP.
  13. 13 ) Lookup Row
  14. 14 ) Lookup Column
  15. 15 ) Return Multiple Items.
  16. 16 ) Can Retrieve whole record.
  17. 17 ) But these methods require a static order and not dependent on Field Names
  18. 18 ) Return Multiple Items with Dynamic Columns. Including Spilled Arrays.
  19. 19 ) These methods are Dynamic! These methods lookup items based on Field Names.
  20. 20 ) Old Methods for returning Records with columns specified in certain Order.
  21. 21 ) New Methods for returning Records with columns specified in certain Order.
  22. 22 ) VLOOKUP and XMATCH. Old and New Together for returning Records with columns specified in certain Order.
  23. 23 ) Rearrange Columns
  24. 24 ) Lookup Cell References
  25. 25 ) Lookup Picture
  26. 26 ) Lookup Table. XLOOKUP is not a good method : (
  27. 27 ) Wildcards
  28. 28 ) Array Formulas
  29. 29 ) Summary

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.