About this tutorial:
Video duration: 00:05:24
Find the link to download the excel file:
Xlookup with more advantages
Can save a lot of time
The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges.
XLOOKUP can lookup data to the right or left of lookup values.
XLOOKUP can return multiple results
XLOOKUP defaults to an exact match
XLOOKUP can work with vertical…