XLOOKUP is Microsoft's modern replacement for VLOOKUP, HLOOKUP, and even INDEX-MATCH. Available in Excel 365 and Excel 2021, it's simpler, more flexible, and eliminates many of VLOOKUP's limitations.
XLOOKUP Syntax
\
Master XLOOKUP — Excel's modern replacement for VLOOKUP. Learn syntax, exact and approximate match, reverse lookup, multiple results, and error handling.