✅ Download the free course files and follow along here:
➡️ https://www.simonsezit.com/ultimate-guide-to-lookup-functions-in-excel-365-course-files
This comprehensive training is designed to deepen your understanding of how to effectively use these powerful tools to streamline data analysis and decision-making processes. From the basics of VLOOKUP and HLOOKUP, perfect for searching vertically and horizontally through rows and columns, to the advanced capabilities of XLOOKUP, which replaces older functions with a more flexible, robust solution, this course covers it all.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Course Introduction
00:01:33 - VLOOKUP (Exact Match)
00:06:54 - Using Named Ranges with VLOOKUP
00:13:14 - VLOOKUP from Another Sheet
00:18:24 - Data Validation Dropdown in VLOOKUP
00:23:13 - VLOOKUP (Approximate Match)
00:29:46 - IFERROR Nested Function with VLOOKUP
00:35:15 - HLOOKUP
00:39:38 - XLOOKUP
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-free/
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 https://www.youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
🔔 Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)