Главная
Study mode:
on
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
Description:
Master the powerful XLOOKUP function in Excel with this comprehensive 25-minute video tutorial. Explore 27 practical examples covering exact and approximate matches, multi-dimensional lookups, dynamic column retrieval, and advanced techniques. Learn how XLOOKUP replaces traditional functions like VLOOKUP and INDEX-MATCH, offering greater flexibility and efficiency. Discover important lessons on array dimensions, spilled arrays, and combining old and new methods for optimal results. Follow along with downloadable start and finished Excel files to enhance your data analysis skills and streamline your spreadsheet workflows.

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Spreadsheets #Array Formulas
0:00 / 0:00
1 of 29

) Introduction