10 Advanced XLOOKUP Tips & Tricks

You don't need a guitar to make your data sing 🎶🎵
You just need XLOOKUP.

In this video, I present 10 advanced tricks to master the XLOOKUP function. Dive in and thank me later :)

~

In this video:

0:00 - XLOOKUP Rockstar - 10 advanced examples
0:50 - Setting up data in a table format
1:15 - XLOOKUP Syntax and basic usage (TRICK 0)
2:30 - Get all columns of data with XLOOKUP (Trick 1)
3:35 - Get all columns, but vertically (Trick 2)
4:18 - Lookup values that begins with (wild card match, Trick 3)
5:42 - Equal to or higher than lookup (Trick 4)
7:02 - Multiple conditions with XLOOKUP (Trick 5)
9:44 - Lookup between two dates (Trick 6)
11:52 - Lookup highest value (Trick 7)
14:34 - Advanced Lookup of highest value (Trick 8)
15:38 - Second matching value (Trick 9)
18:13 - Get all matching values with XLOOKUP (Trick 10)
18:44 - Bonus: XLOOKUP but get two different columns.
20:21 - Other important Excel functions for your success

📂 Download the sample file to practice:
=================================

Get the sample file and practice these 10 tricks today:
https://chandoo.org/wp/wp-content/upl...

Even more examples here: https://chandoo.org/wp/xlookup-examples/

📺 Watch next:
=============

Advanced Excel Functions - Play List
   • Advanced Excel Formula Examples  

Top 10 Excel Functions for Data Analysis
   • Top 10 Excel Functions you should lea...  

Top 10 Excel Functions for Finance People
   • If you work in finance, here are the ...  

Top 10 Excel Functions for Data Cleaning
   • Data Cleaning in Excel - 10 Tricks (B...  

Top 10 Advanced Examples of SUMIFS
   • 10 *next level* SUMIFS tricks only Ex...  

How to use XLOOKUP
   • I don't use VLOOKUP anymore. I use th...  

How to use FILTER
   • I don’t use filters in Excel anymore....  

How to use VLOOKUP
   • Excel VLOOKUP  - Complete tutorial & ...  

How to use IF formula
   • 10 Advanced IF formulas every analyst...  


📚 FULL Excel Course
==================

I run a complete Excel course to make you a rockstar at work. Please check out the program herE:
https://chandoo.org/wp/excel-school-p...

~

Why can't we add guitars? 🎸+ 🎸
Because they are STRING instruments. 😂

#vlookup #xlookup