XLOOKUP (Revised Version) Revealed - 2291 HD

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