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.

Clarification

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.

Members

There is no Extended Cut for this video.

Links

Excel Expert 11
VLookup Tutorial
Basic Functions Tutorial
Absolute References

Learn More!

• FREE Excel Beginner Level 1
• Excel Beginner Level 2 for $1.00
• Excel Forum
• Mailing List Notifications for New Videos

Questions?

Please feel free to post your questions or comments below. Thanks.