✅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 👍🏽 ;-)