This video tutorial will show you how to use XLOOKUP in Microsoft Excel. The XLOOKUP Function can replace the VLOOKUP and HLOOKUP functions in Microsoft Excel. In this tutorial, I will show you why to XLOOKUP and give you 5 examples to see it in action. From a simple exact match to nested XLOOKUPs with the SUM function.

0:00 Introduction
0:50 Why use XLOOKUP in Microsoft Excel
1:38 Find exact match with XLOOKUP
3:35 Find multiple items with XLOOKUP
6:56 Add more arguments to XLOOKUP function
9:46 Used nested XLOOKUP to perform vertical and horizontal match (replace HLOOKUP)
13:54 Use the SUM function with nested XLOOKUP

Practice Worksheets: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ETexIkRWki9MvFe5rH9BvbABnAt6JX160CzkVqeeVYq-5Q?e=bvPc9E