XLOOKUP FUNCTION IN MICROSOFT EXCEL

XLookup function of Microsoft Excel has come to replace the VLOOKUP, HLookup and Index match function. In this video, you will learn six different ways of how to apply the XLookup function. This function is only accessible to Microsoft office 2021 and office 365 version. Click to install office 365 for free https://youtube.com/shorts/hhwWAlJ6dg8?si=06jMIODufSHO2DRi Click here to learn how to use VLOOKUP and Index match function https://youtu.be/IfDujO8R3RQ?si=qhWywuvRsecjBS4Z Click here to access the excel file https://6z0jll-my.sharepoint.com/:x:/g/personal/ugochiiroegbulam_6z0jll_onmicrosoft_com/EV9eYj_4hDlGhA6f2zk8mnABKd_W_D9VVVeuDcz7nMYi9w?e=xzKfYN The timestamps below will help you locate any area that is of interest to you 0:00 - Intro 0:58- What is XLookup function 1:10 - Exact match 3:10 - How to look for values not found with XLook up 4:34 - Wild cards (partial match) with XLookup 8:03 - Two way lookup with XLookup 10:27- Horizontal lookup with XLookup 11:47 - Approximate Match with XLookup 13:50 - Multiple results with X lookup 15:43 - Wrap up