By Richard Rost 7 months ago
How to use the XLOOKUP function in Excel 365
XLOOKUP is a newly added function to Microsoft Excel in 2019 for Microsoft 365 subscribers and is a powerful replacement for VLOOKUP and HLOOKUP. In this example, I'll show you how to look up employee pay rates for your time sheets.
In the video I mention that XLOOKUP is available for Microsoft Excel 2019. My apologies, it is ONLY available for Microsoft 365 subscribers. I believe I read somewhere at the time it was released that they would be adding it to Excel 2019, but apparently it's only for subscribers. Sorry for the confusion.
There is no Extended Cut for this video.
Please feel free to post your questions or comments below. Thanks.