XLOOKUP Excel Function - Solution for VLOOKUP Problems (Simple Guide)

preview_player
Показать описание
XLOOKUP is the most powerful formula in Excel. In this Video you are going to learn "What is XLOOKUP FUNCTION" in Excel. You will also learn "How to use XLOOKUP Function in Excel with help of 9 Practical Examples"

Below are the topics covers here:
00:00 Getting Started with XLOOKUP
00:41 What is XLOOKUP Function in Excel
01:10 How to write XLOOKUP Formula
01:18 Understanding the Arguments of XLOOKUP Formula

PRACTICAL EXAMPLES

02:32 - Simple XLOOKUP and Uses of Wild Characters
04:21 - Lookup Data with two columns or more - Two Way Lookup
05:33 - Write One Formula Get Multiple Outputs with XLOOKUP
09:27 - Lookup Value From Multiple Tables with XLOOKUP
11:24 - Error Handling in XLOOKUP
12:38 - Find Last Lookup or Reverse VLOOKUP with XLOOKUP
16:47 - Find Lookup Values based on Conditions - XLOOKUP
17:11 - Get Top Performer With XLOOKUP

If you wanna support us and want us to write more. You can buy us a coffee from here:

Share the videos with your friends. Thank you
#XLOOKUP #excel #exceltips #exceltricks #vlookup
Рекомендации по теме
Комментарии
Автор

The explanation is helpful. It is better if you include excel exercise files.

engdawadmasu