


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
