Perhaps more importantly, you can use Power Query to transform your data to make it more useful to you. 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. The arrangement of columns and rows does not matter with XLOOKUP.With XLOOKUP, you do not have to specify a column index number as you do with VLOOKUP or a row index number as you do with HLOOKUP.XLOOKUP defaults to an exact match, whereas VLOOKUP and HLOOKUP default to an approximate match.Most will also find XLOOKUP to be even more powerful. Some of the critical differences between XLOOKUP and other lookup functions include: 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. And to clarify, you don't technically need to be a student or home user to buy and use this version, and it still comes with all the essential Office apps that most users want: Word, Excel and PowerPoint.Microsoft added XLOOKUP to Excel provided through Office 365 beginning in February 2020. It'll also receive security updates for a few years longer than the 2016 edition – although the latter is slated to get essential patches until 2025, so there's plenty of life left in it.Īs was the case with its predecessor, the cheapest version of Office 2019 is the 'Home & Student' Edition, which comes with a single user license that allows you to use the suite on one device. It's not a subscription service – you'll only need to pay once to own it – and it adds a variety of new features over its 2016 counterpart, including some that were only previously found in Office 365, although it does cost a little bit more to account for this. Microsoft Office 2019 is the newest standalone version of the staple office suite, and was originally released in September 2018. Image credit: Microsoft (Image credit: Microsoft) Buy Microsoft Office 2019 for the lowest price
0 kommentar(er)
