Microsoft Excel's XLOOKUP function is best known for retrieving a value from a certain row or column in a dataset. However, you can also use this powerful tool to perform two-way lookups ...

INDEX and XMATCH in Excel being used to return an employee's total profit. An Excel table containing employees, their annual profits, and their total profit, with a two-way lookup area on the right.