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