![new functions in excel 2016 new functions in excel 2016](https://trumpexcel.com/wp-content/uploads/2020/02/formula-to-fetch-the-name-with-highest-score.png)
You can use this utility to query data into Excel from countless external data sources, including the databases supporting most major accounting applications. XLOOKUP allows you to specify what happens if your lookup value isn’t found, without having to include an IFERROR function.įirst available with the 2010 release of Excel, the evolution of Power Query is nothing short of remarkable. This is because the function can look to the left or right when using it as an alternative to VLOOKUP. Likewise, it can look above or below when using it as an alternative to HLOOKUP.
![new functions in excel 2016 new functions in excel 2016](https://s3.amazonaws.com/ssi-article-images/office2016/excel-2016/lookup-and-reference-function-1.png)
While these legacy functions will remain in Excel, many users will find XLOOKUP to be more straightforward and intuitive. XLOOKUP offers a superior alternative to VLOOKUP and similar functions such as HLOOKUP and INDEX.
![new functions in excel 2016 new functions in excel 2016](https://i.ytimg.com/vi/Ca7zpIoUYkU/maxresdefault.jpg)
Microsoft added XLOOKUP to Excel provided through Office 365 beginning in February 2020.