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
Watch video 5 *Advanced* lookup tricks that Data Analysts need to know online without registration, duration hours minute second in high quality. This video was added by user Chandoo 06 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 72,773 once and liked it 2.7 thousand people.