Ultimate Guide to Lookup in Excel: VLOOKUP, XLOOKUP, and more |
![]() |
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 ⏩ https://www.simonsezit.com/courses/ 🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ https://www.simonsezit.com/ssit-first-month-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 ✅ Check out our free video playlist for Excel beginners 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z ✅ Excel 2021 Tutorials for Intermediate Users here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3 ✅ 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 👍🏽 ;-) |