XLOOKUP Excel & Google Sheets, XLOOKUP function from Other Worksheets, Join/Merge Data.

00:00 XLOOKUP Excel & Google Sheets
01:59 XLOOKUP Exact Match
08:17 XLOOKUP How to Return Multiple Columns
10:36 XLOOKUP Type Match, How to Fix Errors with Number Lookups
14:26 Join Data/Tables using XLOOKUP
20:49 XLOOKUP from Another Worksheet (Tab)
22:56 XLOOKUP Array Formula in Excel & Google Sheets
25:21 Handle N/A, Custom "If Not Found" Values in XLOOKUP
28:05 XLOOKUP Next Smaller or Larger Item (Similar to Approximate Match VLOOKUP)
35:28 XLOOKUP Wildcard Character Match
42:27 XLOOKUP Find Last Match
45:29 XLOOKUP Binary Search
51:03 XLOOKUP Horizontal Search
53:20 XLOOKUP Horizontal & Vertical Array Mix

#xlookup #excel #googlesheets