💥Get my XLOOKUP course & master this function 👉 https://chandoo.org/wp/lookups-for-data-analysis/
VLOOKUP is the most used Excel function out there. But here is a secret. I no longer use it!!!
That is right. I broke up with VLOOKUP.
I use XLOOKUP now. It is a new function in Excel 365.
So in this video, let me introduce you to my new crush 😍 - The XLOOKUP.
In this video, learn all about:
👉 What is XLOOKUP and how it's better than VLOOKUP
👉 Using XLOOKUP in business situations
👉 Errors & XLOOKUP (if not found option)
👉 XLOOKUP with tabular data
👉 Wildcard (pattern) matching with XLOOKUP
👉 Returning multiple values with XLOOKUP
👉 XLOOKUP vs. HLOOKUP
Video topics ⏱👇
==============
0:00 - VLOOKUP & XLOOKUP - Quick examples
2:13 - Difference between VLOOKUP & XLOOKUP
2:30 - Using XLOOKUP instead of INDEX + MATCH
3:32 - Dealing with Errors (#N/A) using XLOOKUP
4:57 - XLOOKUP with Tabular Data (tables)
5:40 - Wild card (pattern matching) with XLOOKUP
7:40 - Returning multiple values with XLOOKUP
9:10 - XLOOKUP works horizontally too!!!
Example file (with many many XLOOKUPs) 🟩👉
=======================================
Here is a sample file with many many XLOOKUP examples - https://chandoo.org/wp/wp-content/uploads/2022/04/I-no-longer-vlookup.xlsx
If you want more, check out this article: https://chandoo.org/wp/xlookup-examples/
Or join my mini-course on various lookup functions in Excel here - https://skl.sh/3hbR49d
Watch next 👨💻👩💻👉
================
FILTER function - https://youtu.be/JuTdj2j-9Kg
Spill Behaviour in Excel (# operator) - https://youtu.be/kR6czKY4FEw
VLOOKUP explained - https://youtu.be/8rtvDQVQaA0
INDEX+MATCH explained - https://youtu.be/kly0uPIM4IU
#excel #xlookup
~
What does Charles Xavier use to find mutants?
XLOOKUP of course 🤣