XLOOKUP Function Definition. The XLOOKUP Excel function finds specific values in an array range vertically or horizontally, with an approximate, exact, or ...