How to Enable XLOOKUP in Excel
To access the XLOOKUP function in Excel, you need to be using a version of Excel that supports it.
Excel 365
XLOOKUP is included in Excel 365, which is a subscription-based version of Excel that receives regular updates and new features.
Excel 2019
XLOOKUP was introduced in Excel 2019, which is a one-time purchase version of Excel. However, it might not be available in older versions of Excel, such as Excel 2016 or earlier.
XLOOKUP Function in Excel With Examples
XLOOKUP Function helps us to search value in a horizontal or vertical dataset and return the relative value in some other row or column. In this article, we will look at the XLOOKUP Function in Excel. XLOOKUP is a modern replacement for functions like HLOOKUP, VLOOKUP, and LOOKUP. XLOOKUP supports approximate and exact matching, wildcards for partial matches, and lookups in horizontal or vertical ranges. XLOOKUP can be performed in Microsoft 365.