Unlock the power of Excel's lookup functions with our comprehensive tutorial! Master VLOOKUP for exact and approximate matches and explore horizontal lookups with HLOOKUP. Dive deeper into flexible lookups using INDEX and MATCH and discover modern alternatives like XLOOKUP and XMATCH. Learn to easily handle duplicates and leverage advanced techniques with the CHOOSE and SWITCH functions. Elevate your spreadsheet skills and streamline your data retrieval processes. Subscribe for more Excel tips, and don't miss out on mastering lookup functions with our in-depth course.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! Timestamps:
00:00:00 - Simon Sez IT Intro
00:00:09 - VLOOKUP: Exact and Approx Match
00:08:46 - Horizontal Lookups: HLOOKUP
00:15:14 - Flexible Lookups: INDEX and MATCH
00:22:58 - Modern Lookups: XLOOKUP and XMATCH
00:30:42 - Lookups with Duplicates
00:37:41 - Lookups with the CHOOSE Function
00:42:00 - The SWITCH Function
00:46:32 - Exercise 04
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ [ Ссылка ]
🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ [ Ссылка ]
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
[ Ссылка ]
✅ Check out our free video playlist for Excel beginners 👉[ Ссылка ]
✅ Excel 2021 Tutorials for Intermediate Users here 👉[ Ссылка ]
✅ Microsoft Excel Tips and Tricks 👉[ Ссылка ]
✅ Microsoft Office 2021 and Office 365 Training here 👉[ Ссылка ]
💬Stay in touch!
SimonSezIT.com: [ Ссылка ]
LinkedIn: [ Ссылка ]
FaceBook: [ Ссылка ]
🔔 Subscribe to our channel:
[ Ссылка ]
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
