Summary
Keywords
Full Transcript
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/uploads/2021/07/5-lookup-tricks.xlsx Thank you and happy lookups. #VLOOKUP #ExcelTips
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
