XLOOKUP is a Formula 1 XLOOKUP is the new Excel function to find data in a reference table. The function merge the benefits of VLOOKUP and INDEX