XLookup-function

XLOOKUP is the newest member of Excel lookup function family. The XLOOKUP function in excel usually lookup or search for a single value in an array or range.