LOOKUP Functions in Excel VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial

✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩ https://www.simonsezit.com/excel-biz-analysis-instructor-files/ In this hour-long Lookups tutorial, we teach you how to use the essential lookup functions that Microsoft Excel has to offer. We start with a VLOOKUP tutorial, followed by an HLOOKUP tutorial. After that, we move on to using INDEX and MATCH to create a lookup, and finally, we look at the awesome XLOOKUP as a replacement for all the other lookups! This Excel tutorial is a must-watch tutorial if you're using lookups in Excel. 📝Video Markers: 0:00:19 - Vlookup Exact Match 0:11:11 - Vlookup Approximate Match 0:17:39 - Vlookup with Expanding Data 0:27:39 - Using Hlookup 0:39:58 - Combining Vlookup and Match 0:52:21 - Using Index, Match and Xlookup ✅Check out the rest of the videos in this playlist ⏩https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi ✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩ https://www.simonsezit.com/excel-biz-analysis-instructor-files/ 🌍 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/ Check out our Excel 2021 tutorials for beginners playlist here ✅https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb Check out our FREE 300+ hour training course playlist here ➡️ 🔥https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 💻Watch more popular tutorials from Simon Sez IT: ✅Microsoft Office 2021 and Office 365 Training Tutorials playlist 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j ✅Microsoft Office 2019 Training Tutorials for Beginners playlist 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2OE0G9fSMaVjcW4qi_z_7 ✅ PivotTable training here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc 💬Stay in touch! ✅SimonSezIT.com: 👉https://www.SimonSezIT.com/ ✅StreamSkill.com: 👉https://StreamSkill.com/ ✅YouTube Channel: 👉https://www.youtube.com/user/simonsezittraining ✅LinkedIn: 👉https://www.linkedin.com/company/simon-sez-it/ 🔔Subscribe to our channel: https://www.youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)