XLOOKUP is now one of the most widely used lookup functions in Excel, but many users still ask an important question. When did XLOOKUP come out and how did it become part of Excel?
Knowing the release timeline helps explain why some Excel versions include XLOOKUP while others do not, and why it is considered a modern replacement for older lookup formulas.
When Was XLOOKUP Introduced in Excel?
XLOOKUP was officially introduced by Microsoft in August 2019.
It first appeared in Excel for Microsoft 365, which receives ongoing feature updates. At launch, Microsoft described XLOOKUP as the future of Excel lookups, designed to replace VLOOKUP, HLOOKUP, and many INDEX MATCH use cases.
Why Did Microsoft Release XLOOKUP?
Before XLOOKUP, Excel users relied on older functions that had well known limitations.
Common problems included:
- Formulas breaking when columns were inserted
- Dependence on column index numbers
- Difficulty performing left side lookups
- Complex formulas that were hard to maintain
XLOOKUP was created to solve these issues with a single, flexible function that worked in all directions and returned exact matches by default.
Which Excel Versions Support XLOOKUP?
XLOOKUP availability depends entirely on the Excel version you are using.
XLOOKUP is available in:
- Excel for Microsoft 365
- Excel 2021
- Excel 2024 and newer versions
XLOOKUP is not available in:
- Excel 2019
- Excel 2016
- Older perpetual versions
This version limitation is the most common reason users cannot access XLOOKUP.
Was XLOOKUP Released Outside Excel?
Yes. After its success in Excel, XLOOKUP was later added to Google Sheets.
Although the release came later than Excel, the function works in a very similar way and follows the same core logic. This made XLOOKUP useful across spreadsheet platforms.
How XLOOKUP Changed Lookup Functions
Since its release, XLOOKUP has become the recommended lookup function because it:
- Uses exact matching by default
- Allows left and right lookups
- Includes built in error handling
- Works with dynamic arrays
- Replaces multiple older functions
For new spreadsheets, Microsoft now encourages users to choose XLOOKUP over older alternatives.
Quick Timeline Overview
| Event | Year |
| XLOOKUP announced by Microsoft | 2019 |
| First released in Excel | 2019 |
| Added to Excel 2021 | 2021 |
| Added to Google Sheets | Later years |
Final Answer
So, when did XLOOKUP come out?
XLOOKUP was introduced in August 2019 as part of Excel for Microsoft 365. It later became available in newer standalone Excel versions and expanded to Google Sheets.
Since its release, XLOOKUP has transformed how users perform lookups and is now considered the modern standard.
