XLOOKUP Formula

XLOOKUP() is the newest function in Excel’s group of basic lookup functions, which also includes LOOKUP(), VLOOKUP(), HLOOKUP(), and now XLOOKUP(). It has many benefits, including more features and more…