XLOOKUP FUNCTION Use XLOOKUP function to find things in a table or range by row. For example, to find an employee name based on his employee ID. Explained in this video: 615 viewsedited 14:47