How to use the XLOOKUP Function in Microsoft Excel - Beginners Tutorial

Описание к видео How to use the XLOOKUP Function in Microsoft Excel - Beginners Tutorial

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.share...

Комментарии

Информация по комментариям в разработке

Похожие видео