Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the�price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.