Here is a look at the final version of XLOOKUP, along with 10 benefits of XLOOKUP over VLOOKUP, HLOOKUP, LOOKUP, INDEX/MATCH.
Table of Contents
(0:25) List of Benefits
(2:30) First XLOOKUP
(3:02) 3rd argument is not an integer
(3:29) Handle items not found
(3:51) Range lookup find value just less like VLOOKUP(,,,True)
(4:41) Find value just larger like MATCH – without sorting
(5:16) HLOOKUP replaced by XLOOKUP
(5:30) Search from bottom of table
(6:21) Wildcards in XLOOKUP versus VLOOKUP
(6:56) Return all 12 months from table with single formula
(7:38) XLOOKUP can return a cell reference XLOOKUP:XLOOKUP
(9:10) Two-Way Match
(10:09) Sum All lookups
(10:44) Twisted XLOOKUP
(11:13) Wrap up on XLOOKUP
(11:30) Swag at Ignite Conference