5 *Advanced* lookup tricks that Data Analysts need to know
VLOOKUPS & coffee drive most of the world's economy. No kidding.
In this video, let me present you with 5 advanced tricks when working with Excel's most used function - The VLOOKUP.
These tricks are,
1) Pattern matching
2) Looking up in two tables
3) Multi-column results
4) Combine all matches with IF
5) A better function
👉 Get my Excel Lookups Crash Course on SkillShare 💻
===============================================
https://chandoo.org/lookups
You will get FREE 1 month premium access 🎁 when you join with the above link.
⏱ Video chapters & timestamps
===========================
0:00 - Intro
0:46 - Pattern matching
1:26 - Lookup in two tables
2:14 - Multi-column results
3:21 - Combine all matches with IF
4:25 - A better option (XLOOKUP)
5:09 - Course announcement
📃🟩 Sample File
===============
https://chandoo.org/wp/wp-content/upl...
Thank you and happy lookups.
#VLOOKUP #ExcelTips