10 Advanced XLOOKUP Tips & Tricks @chandoo_
10 Advanced XLOOKUP Tips & Tricks  @chandoo_
Uploaded November 2023 | Updated November 2026, 1 hour ago
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:
chandoo.org/wp/wp-content/uploads/2023/11/xlookup-10-adv-examples-practice.xlsx

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

πŸ“Ί Watch next:
=============

Advanced Excel Functions - Play List
youtube.com/playlist?list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_

Top 10 Excel Functions for Data Analysis
youtu.be/HgNCvd8IbSc

Top 10 Excel Functions for Finance People
youtu.be/xarUaqsjmFY

Top 10 Excel Functions for Data Cleaning
youtu.be/q7EpoOwBcnM

Top 10 Advanced Examples of SUMIFS
youtu.be/YEt-aYbDTrs

How to use XLOOKUP
youtu.be/DDlZXXEI1bU

How to use FILTER
youtu.be/JuTdj2j-9Kg

How to use VLOOKUP
youtu.be/8rtvDQVQaA0

How to use IF formula
youtu.be/-yFpzIRifK4


πŸ“š FULL Excel Course
==================

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

~

Why can't we add guitars? 🎸+ 🎸
Because they are STRING instruments. πŸ˜‚

#vlookup #xlookup
10 Advanced XLOOKUP Tips & TricksHow to make an employee time tracker with Excel [Easy setup]This formula changes how you make dashboards [TOPN in One Cell]Dynamic Moving Average with Excel OFFSETWhats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?Here is why I think Excel skills are still relevant in the age of AIHow to implement Dense Rank in Excel (easy formula)3 Resume Tips for Data Analysts that actually work #jobsearchTop 10 Power BI Interview Questions (based on what I usually ask)5 POWER Tips to Analyze Data in Excel - End to End Project with Real Life DataHow to use DAX to analyze New vs. Returning Customers in Power BIClustered column chart with totals in Excel
Chandoo |

10 Advanced XLOOKUP Tips & Tricks

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER