There are still benefits to the free version, including the ability to share links to your work and collaborate in real time, similar to what the Google Workspace (formerly G Suite) productivity tools allow. They also have fewer features than the full Microsoft 365 versions. You might be saying, 'Wait a minute, if I can get all of those apps for free, why pay for Microsoft 365 in the first place?' The functionality of the free apps is limited, so they only run in your web browser and you can only use them while you're actively connected to the internet. Screenshot by Alison DeNisco Rayome/CNET So what's the catch for the free version? However, you may see XLOOKUP show up while using Excel 2019 if you receive an Excel file that was created with a later version of Excel and the XLOOKUP function was added.Use the browser-based version of the Microsoft Word app for free.

The XLOOKUP function is not included in Excel 2019 or any prior version of Microsoft Office for Mac. However, you may see XLOOKUP show up while using Excel 2016 if you receive an Excel file that was created with a later version of Excel and the XLOOKUP function was added. The XLOOKUP function is not included in Excel 2016 or any prior version of Microsoft Office. Does Excel 2016 Include XLOOKUP Function? With the release of Excel 2021 for both PC and Mac, Microsoft included the XLOOKUP function along with many other improvements. What Was the First Perpetual License Version of Excel With XLOOKUP In It? The function remained in beta for approximately 7 months while a small population of Excel users tested the function.ĭuring the beta run, the If_Not_Found input was moved to be the first optional function input based on feedback from the Excel community. Prior to this date, the XLOOKUP function was pushed to the Beta version of Excel on August 28, 2019. The XLOOKUP function was publically released to the monthly channel of Microsoft 365 (subscription-based) on March 31, 2020.

What Was the First Excel Version With XLOOKUP In It? The following versions of Microsoft Excel include the XLOOKUP function:Įxcel for Microsoft 365 Subscriptions (PC and Mac Versions) Versions Of Microsoft Excel For XLOOKUP Function

Ms excel 2021