XLOOKUP in Excel 2019

[Rblack40]

When will XLOOKUP and the other new functions be added into Excel Office 365 or Excel 2019? Will I have to know it for the test?

 

[Fluff]

The new functions will not be added to Xl2019, they will be rolled out to 365 subscribers as and when MS are happy that they have sorted out any bugs. There is no fixed timetable.

 

[Rblack40]

I have been studying for Excel certification and trying to examine all the new functions.

 

[sandy666]

from MS

Note: August 28, 2019: XLOOKUP is currently a beta feature, and only available to a portion of Office Insiders at this time. We'll continue to optimize it over the next several months. When XLOOKUP is ready, we'll release it to all Office Insiders, and Office 365 subscribers.

 

[Fluff]

Whilst I don't know anything about the certification requirements, I would be surprised if you need to know the new functions, as they are not generally available yet.

 

[Fluff]

If you want to find out more, about the new functions and the like, have a look here
https://www.mrexcel.com/products/excel-dynamic-arrays-straight-to-the-point/