I don't use VLOOKUP anymore. I use this instead....

💥Get my XLOOKUP course & master this function 👉 https://chandoo.org/wp/lookups-for-da...

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/upl...
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 -    • I don’t use filters in Excel anymore....  
Spill Behaviour in Excel (# operator) -    • Excel Dynamic Arrays and How to use t...  
VLOOKUP explained -    • Excel VLOOKUP  - Complete tutorial & ...  
INDEX+MATCH explained -    • Excel's INDEX + MATCH - How to use it...  

#excel #xlookup

~

What does Charles Xavier use to find mutants?
XLOOKUP of course 🤣