Use the XLOOKUP function to find things in a table or 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.

Instead of using INDEX and MATCH in Excel to perform a left lookup, simply use the XLOOKUP function. For example, take a look at the XLOOKUP function below. Explanation: the XLOOKUP …

Jun 25, 2024 · Searches a range or an array for a match and returns the corresponding item from a second range or array. It’s the specified value that needs to be searched for in the data table. The …

Aug 14, 2025 · With added benefits like default exact matching and the ability to handle errors more gracefully, XLOOKUP makes data retrieval in Excel easier and more reliable. In this article, we will …

Aug 29, 2024 · Sounds easy, right? 😎 We will start the XLOOKUP function with a simple example. Let’s use the XLOOKUP function and find the price for the given product code in cell F1.

Feb 6, 2020 · In this tutorial, I will cover everything there is to know about the XLOOKUP function and some examples that will help you know how to best use it. So let’s get started! What is XLOOKUP? …

May 6, 2025 · XLOOKUP is Excel's modern all‑in‑one lookup function. It lets you search a row or column for a value and retrieve the corresponding value from another range, without the frustrating …

Mar 20, 2025 · Microsoft Excel has changed a lot over the years. The XLOOKUP function is a big improvement. It's more powerful and easier to use than VLOOKUP and HLOOKUP. In this post, we'll …

Aug 14, 2025 · If you're working in the Excel desktop app on a PC or Mac, you need to be using Excel 2021 or later (including Excel for Microsoft 365) to use the XLOOKUP function. It's also readily …

For instance, we can use the XLOOKUP function to find an employee’s department based on their ID using the data in the excel sheet. First, we will create an employee ID reference cell in E1 containing …