Completed
) VLOOKUP and XMATCH. Old and New Together for returning Records with columns specified in certain Order.
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
