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:
[ Ссылка ]
Even more examples here: [ Ссылка ]
📺 Watch next:
=============
Advanced Excel Functions - Play List
[ Ссылка ]_
Top 10 Excel Functions for Data Analysis
[ Ссылка ]
Top 10 Excel Functions for Finance People
[ Ссылка ]
Top 10 Excel Functions for Data Cleaning
[ Ссылка ]
Top 10 Advanced Examples of SUMIFS
[ Ссылка ]
How to use XLOOKUP
[ Ссылка ]
How to use FILTER
[ Ссылка ]
How to use VLOOKUP
[ Ссылка ]
How to use IF formula
[ Ссылка ]
📚 FULL Excel Course
==================
I run a complete Excel course to make you a rockstar at work. Please check out the program herE:
[ Ссылка ]
~
Why can't we add guitars? 🎸+ 🎸
Because they are STRING instruments. 😂
#vlookup #xlookup
