Xlookup in Excel




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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads