Get my XLOOKUP course & master this function https://chandoo.org/wp/lookupsforda...

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/wpcontent/upl...
If you want more, check out this article: https://chandoo.org/wp/xlookupexamples/
Or join my minicourse 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