Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples

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