XLOOKUP Excel Function - Solution for VLOOKUP Problems (Simple Guide)
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
You can also get this training and more resources here https://www.excelsirji.com
If you wanna support us and want us to write more. You can buy us a coffee from here:
https://www.buymeacoffee.com/excelsirji
Share the videos with your friends. Thank you
#XLOOKUP #excel #exceltips #exceltricks #vlookup
