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-...

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 ⏩   • Data Analysis using Microsoft Tools  

✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩
https://www.simonsezit.com/excel-biz-...

🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

🚀 Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first...

Check out our Excel 2021 tutorials for beginners playlist here
✅   • Excel 2021/365 Training Tutorials for...  

Check out our FREE 300+ hour training course playlist here ➡️
🔥   • Simon Sez IT Long Training Courses  

💻Watch more popular tutorials from Simon Sez IT:

✅Microsoft Office 2021 and Office 365 Training Tutorials playlist
👉   • Microsoft Office 2021 and Office 365 ...  

✅Microsoft Office 2019 Training Tutorials for Beginners playlist
👉   • Microsoft Office 2019 Training Tutori...  

✅ PivotTable training here 👉    • Pivot Tables - All you can Eat - Dine...  

💬Stay in touch!
✅SimonSezIT.com: 👉https://www.SimonSezIT.com/
✅StreamSkill.com: 👉https://StreamSkill.com/
✅YouTube Channel: 👉   / simonsezittraining  
✅LinkedIn: 👉  / simon-sez-it  

🔔Subscribe to our channel:
https://www.youtube.com/simonsezittra...

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)