Excel xlookup function. Guide to XLOOKUP Function in Excel.

Excel xlookup function Jun 8, 2025 · Master Excel's XLOOKUP function with this comprehensive guide. What are the XLOOKUP & VLOOKUP functions in Excel? The XLOOKUP and VLOOKUP functions in Excel are used to find, or 'lookup', a value from a table or a list and then return a related result. You might find it useful to bookmark this page to refer back to, during later sections of the tutorial. It works by showing you matching info from the same row but another column. In the example shown, the formula in H8 is: =XLOOKUP(1,(B5:B15=H5)*(C5:C15=H6)*(D5:D15=H7),E5:E15) XLOOKUP returns $29. Mar 22, 2023 · Luckily, Microsoft Excel often provides more than one way to do the same thing. It shows the function name, complete syntax format, argument requirements, and return value characteristics. However, you may come across a situation of using a workbook in Excel 2016 or Excel 2019 with the XLOOKUP function in it, if it was created by someone else using a newer version of Excel. The lookup values must appear in the first column of the table, and the information to retrieve is specified by column number. To Vlookup multiple criteria, you can use either an INDEX MATCH combination or the XLOOKUP function recently introduced in Office 365. In the example shown, the formula in H6 is: =XLOOKUP(H5,months,XLOOKUP(H4,names,data)) where months (C4:E4) and names (B5:B13), and data (C5:E13) are named ranges. Learn how to use it here. Aug 14, 2025 · The XLOOKUP function in Excel is a powerful and flexible tool designed to replace older lookup functions like VLOOKUP and HLOOKUP. It can look in any direction, return last match, perform v-lookup or h-lookup with multiple criteria, two-way lookup, and more. It was introduced in Microsoft Office 365 as a replacement for the traditional VLOOKUP and HLOOKUP functions, offering improved functionality and flexibility. Here we learn to use it for two-way & horizontal lookups, with examples & a downloadable excel template. Here are 10 VLOOKUP Examples that will make you a VLOOKUP pro + a FREE VLOOKUP Ebook This Excel Vlookup Tutorial provides a step-by-step guide of how to use the Excel Vlookup function, providing examples and advice on fixing common Vlookup errors. Learn all about it in this Excel VLOOKUP tutorial. In this resource, we’ll discuss XLOOKUP vs VLOOKUP with examples of how to use each. These new functions work in any direction and return exact matches by default, making them easier and more convenient to use than their predecessors. This function has many more advanced functionalities over the age-old lookup functions like INDEX/MATCH and VLOOKUP/HLOOKUP formula in excel. It’s like a more advanced version of VLOOKUP or HLOOKUP, but way more flexible. Feb 2, 2024 · See how to use the XLOOKUP function for vertical and horizontal lookup in Excel. Perfect for beginners and advanced users. Jul 9, 2025 · The Excel VLOOKUP function is used to retrieve information from a table using a lookup value. Dec 16, 2024 · Learn how to use the VLOOKUP function in Excel with Inside Excel's step-by-step guide, examples, and practice exercises. Note the lookup_value in XLOOKUP is 1 since the logical expressions in lookup_array create an array of 1s and 0s. Aug 30, 2024 · With VLOOKUP in Excel, you can quickly find things in a big list. May 26, 2024 · Unlock the power of Excel XLOOKUP Function! Learn syntax, exact & approximate matches, error handling, and advanced techniques. It is similar to VLOOKUP and HLOOKUP, but with greater simplicity and flexibility. XLOOKUP offers various options to retrieve data based on different conditions, making it a more XLOOKUP is a versatile and advanced addition to the Excel lookup functions. Go through the 6 examples and practice by yourself. Home » Excel-Built-In-Functions » Excel-Lookup-And-Reference-Functions » Excel-Vlookup-Function The Excel VLOOKUP Function Function Description The Excel VLOOKUP function 'looks up' a given value in the left-hand column of a data array (or table), and returns the corresponding value from another column of the array. Perfect for beginners and pros alike, learn syntax, examples, and advanced. Learn how to use the XLOOKUP function in Excel 365/2021 to perform exact, approximate, left, horizontal and multiple lookups. This Excel tutorial explains how to use the Excel VLOOKUP function with syntax and examples. Vlookup Syntax & Rules This page provides details of the Vlookup function syntax and rules of use. Mar 18, 2021 · The excel XLOOKUP function is a newly introduced lookup formula/function in excel. Sep 16, 2025 · Build better lookup formulas with Excel XLOOKUP function. It is typed =VLOOKUP and has the following parts: Aug 3, 2024 · The XLOOKUP function in Excel is a powerful and versatile lookup function that allows you to search for a value in a range or array and return a corresponding value in another range or array. Here we learn how to use Vlookup formula with the examples and a downloadable excel template. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data May 16, 2024 · To configure XLOOKUP with Boolean OR logic, use a lookup value of 1 with a logical expression based on addition. Additionally, while XLOOKUP only has three required arguments Oct 28, 2024 · The XLOOKUP function in Excel is one of the most powerful tools for searching and retrieving data. For example, to look up based on 3 different values (Date, Customer name and Product), use one of the following formulas: Jun 27, 2024 · In this article, I explained 4 easy ways to perform XLOOKUP with Multiple Criteria. VLOOKUP in Excel is useful for looking for specific information in your worksheet. Jun 28, 2024 · This article shows how to use vlookup with if condition in Excel. Simplify your data searches and boost productivity! Mar 9, 2023 · The XLOOKUP function is a replacement for Excel’s traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). Tip: Try using the new XLOOKUP and XMATCH functions, improved versions of the functions described in this article. Apr 10, 2024 · Discover the power of Microsoft Excel’s XLOOKUP function, a game-changer for efficient data searching and retrieval in your spreadsheets. Aug 13, 2024 · The best way to use XLOOKUP with multiple criteria is to use Boolean logic to apply conditions. VLOOKUP Function The VLOOKUP function is a premade function in Excel, which allows searches across columns. Here, we learn how to use it, its formula, examples, and downloadable excel template. Here's what you need to know. Feb 21, 2020 · To perform a two-lookup with the XLOOKUP function (a double XLOOKUP), you can nest one XLOOKUP inside another. Mar 20, 2025 · The XLOOKUP function is a game-changer and should be your go-to for most lookup scenarios in Excel. For example, while VLOOKUP can only search for values to the right of the lookup column, XLOOKUP can search left or right, and with fewer arguments. This will be followed by practical examples of the Vlookup function to help you to put this information to use. XLOOKUP is an improvement over VLOOKUP, HLOOKUP, and INDEX MATCH, with built-in error handling, multiple results, and wildcard matches. Aug 23, 2025 · Master Excel XLOOKUP function with our comprehensive guide. Step-by-step examples to help you get started, or learn more! Written steps, video, Excel file. Aug 29, 2024 · Excel’s new XLOOKUP function is an improvement over the old (but very popular) VLOOKUP function. Aug 29, 2024 · Learn how to use the new XLOOKUP function in Excel with this comprehensive guide. The syntax of the XLOOKUP function is as follows: The Excel XLOOKUP function searches for a value, offering flexible matching options and improvements over VLOOKUP and HLOOKUP. Introduced in 2019, XLOOKUP is an upgrade to the VLOOKUP and HLOOKUP functions, providing more flexibility and functionality. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Feb 9, 2023 · This tutorial will demonstrate how to combine the XLOOKUP and IF functions in Excel. Click here for a step-by-step tutorial on how to use the XLOOKUP function in Excel! XLOOKUP Function in Excel The XLOOKUP function in Excel is a newer function, introduced in Excel 365. Jul 19, 2024 · Learn how to use Excel’s powerful XLOOKUP function with our easy step-by-step guide for beginners. Oct 2, 2023 · The XLOOKUP function searches a range or an array for a match and returns the corresponding item from a second range or array. They will still be there and available to use. Read below for details For a more detailed XLOOKUP vs VLOOKUP comparison read on. Note: see below for an equivalent formula based on INDEX and MATCH. These ways will help you to use XLOOKUP function. Learn syntax, common errors, and real-world applications. In just a few steps, you can use XLOOKUP to find data in your tables. In Excel 365 and Excel 2021, you can use the XLOOKUP function, which is a more flexible and powerful successor of VLOOKUP. Tip. The function requires 3 inputs, the key which is the value you are looking for, the array of values to look for the key. In this article, I will explore the concept of XLOOKUP in Excel, its syntax, and its practical applications. It's simple, flexible, and eliminates the limitations of older functions. It has a new set of arguments and is available in Excel 2021 and 365. Apr 4, 2025 · This table breaks down the essential components of the XLOOKUP function. Jun 25, 2024 · XLOOKUP is a lookup function that searches a range or an array for a match and returns the corresponding item from a range or array in Excel. See examples, explanations and tips for spilling and last match. Guide to Vlookup Function in Excel. 00, the price for a Medium Blue Hoodie. The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. 2 days ago · Learn how to use regex match in Excel XLOOKUP and XMATCH to search patterns, validate formats, and work with structured data, complete with formula examples and practical tips. Guide to XLOOKUP Function in Excel. The XLOOKUP function in Excel handles vertical or horizontal arrays and supports exact matches, wildcards, and binary searches. Microsoft won’t be removing them from Excel. The XLOOKUP Function [1] in Microsoft Excel allows us to look for specific entries in a large array of data. May 21, 2025 · Learn how to use VLOOKUP in Excel with this easy step-by-step guide. VLOOKUP is the most popular Excel function. Jun 12, 2023 · This tutorial explains how to use the XLOOKUP function in Excel with an IF statement, including an example. Learn syntax, examples, and advanced techniques for modern lookup formulas that replace VLOOKUP and HLOOKUP. Basic XLOOKUP Example This example demonstrates the simplest use of XLOOKUP to find a product price. Unlike these traditional functions, XLOOKUP can search both vertically and horizontally, making it ideal for retrieving specific values from any range in a table. Includes numerous formula examples in Excel and VBA (WITH PICTURES). Nov 9, 2019 · XLOOKUP Function Explained XLOOKUP function is used for looking up a value in a range, and return its corresponding value. It is the successor to VLOOKUP and HLOOKUP and is a huge improvement. Dec 16, 2019 · The new XLOOKUP function is now available in Excel. 2 days ago · Using the VLOOKUP Excel function can save you a ton of time when searching your spreadsheets. Jan 24, 2023 · The XLOOKUP function is a powerful and versatile tool that can help you find values quickly in Excel. If your version of Excel does not support XLOOKUP, read how to use Dec 7, 2023 · Excel’s XLOOKUP function has evolved as a modern replacement for VLOOKUP and HLOOKUP, combining their capabilities and offering enhanced features. XLOOKUP is not available in Excel 2016 and Excel 2019, but you may encounter it in newer versions of Excel. Learn how to find and retrieve data effortlessly. Nov 3, 2025 · Now that XLOOKUP has made both these function obsolete, what will happen to VLOOKUP and HLOOKUP? We will still need to use them if we plan on sharing our workbook with anyone not on Office 365 since XLOOKUP is not available in any other Excel version. Jun 18, 2025 · Learn how to use XLOOKUP function in Excel using this step-by-step tutorial with 10 practical examples and a free sample workbook. Jun 17, 2024 · Using the XLOOKUP function in Excel is a simple way to search for specific information in your spreadsheets. In the example shown, the formula in G5 is: =XLOOKUP (1, (data [Color]="red")+ (data [Color]="pink"),data) where data is the name of the Excel Table in the range B5:E14. Learn how to use the XLOOKUP function to find things in a table or range by row, with examples and syntax. It allows you to look up a value from an array in a range or table and return one or more results. Includes practical examples, formulas, visuals, and tips to avoid common VLOOKUP errors. Vlookup Syntax The syntax of the Excel Vlookup function is: Guide to XLOOKUP excel function. Master the VLOOKUP function in Excel with step-by-step examples. Excel XLOOKUP Function Examples XLOOKUP is a versatile function and will allow the average Excel user to conquer tasks that previously required multiple functions. This guide will walk you through each step, ensuring you understand how to use this function effectively. Jul 11, 2024 · Master the VLOOKUP function in Excel with our easy-to-follow tutorial. Aug 23, 2023 · The function is available in all versions of Excel 365 through Excel 2007. Note: XLOOKUP is not available in Excel 2016 and Excel 2019. Feb 9, 2023 · Learn how to use Excel's VLOOKUP function for both Mac and PC. As you can see from this tutorial, you can utilize it in many ways by combining it with other functions. May 13, 2024 · The XLOOKUP Function in Excel searches a dataset in a range or array to return the corresponding value(s) based on the user-defined criteria. XLOOKUP is a SUPER-FUNCTION, which combines the best features from various popular Excel functions, such as VLOOKUP, INDEX MATCH, IFERROR/IFNA, HLOOKUP and many more! Jul 11, 2024 · XLOOKUP function is a powerful lookup function in Microsoft Excel that allows you to search and retrieve data from a range of cells.