Excel XLOOKUP Function. The XLOOKUP function looks for a value in a range, and returns the matching result. It works both vertically and horizontally, ...