I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.

We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). As such, it makes sense to make this as broadly available as possible. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc. I’m happy to announce that your input has had another direct impact on the product. 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.Microsoft has just announced that Excel Power Pivot will now be available in all Windows editions of Excel, which is awesome news and a step in the right direction.

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

Excel 2021 version