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

✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩
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 Mi...
✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩
www.simonsezit.com/excel-biz-...
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
Check out our Excel 2021 tutorials for beginners playlist here
✅ • Excel 2021/365 Trainin...
Check out our FREE 300+ hour training course playlist here ➡️
🔥 • Simon Sez IT Long Trai...
💻Watch more popular tutorials from Simon Sez IT:
✅Microsoft Office 2021 and Office 365 Training Tutorials playlist
👉 • Microsoft Office 2021 ...
✅Microsoft Office 2019 Training Tutorials for Beginners playlist
👉 • Microsoft Office 2019 ...
✅ PivotTable training here 👉 • Pivot Tables - All you...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅KZbin Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
🔔Subscribe to our channel:
kzbin.info...
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)

[@SimonSezIT]

Download the instructor files and follow along! www.simonsezit.com/excel-biz-analysis-instructor-files/

[@SleepEatWorkRepeat]

Why do none of these links work? They never send the downloads to my email.

[@victormayer5665]

the files are not available anymore...

[@dexxxxxxxx]

Links not working

[@hautecommercialrealestate2114]

I've been using Excel for over 30 years, and the presentation and syntax of this course and its content is among the best I've ever experienced. Makes diving into the Black Hole of Excel fun and interesting!

[@realvirtualdemand4222]

this is a great tutorial and how to get out excel skills up to par..

[@cliffordeaton5455]

Thank you so much for the great instructional videos. For newbies like me, they're worth their weight in gold!

[@SimonSezIT]

Glad you like them!

[@sargonkheedo]

Deb, is the best of the best... thank you Simon Sez it... this is by far the most detailed easy to learn .. thank you

[@genesisfincorp88]

It is wonder session of advance excel. learnt a lot. ❤❤

[@SimonSezIT]

Glad you think so!😊 We have additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@1sornram]

so freaking helpful! thanks a bunch

[@poodleseigien]

Best instructor!

[@ziaglos]

Just like it. Thank you Deb 👏👏👍

[@SimonSezIT]

Glad you like it

[@shijogeorgethomas7830]

Perfect Explanation🙂

[@amitpanchal135]

I am so glad mam from meet you

[@jamesdep8128]

Great class. Thank you again!

[@SimonSezIT]

Thanks for watching James!🙃

[@jamesdep8128]

@@SimonSezIT I am watching all of your videos. it is greatly helping me in my training.

[@justinoroy]

Thank u so much, keep doing great!

[@SimonSezIT]

Thanks for watching Justino!

[@jessieren1296]

It helps a lot! Thank you so so much!

[@SimonSezIT]

You're welcome!

[@nstcoffice3533]

Thank you for such a nice tutorial

[@SimonSezIT]

You're welcome 😊

[@idowumayowadavid886]

Thanks so much . I just received the file for free

[@SimonSezIT]

Great! We have additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@chutatipwattana399]

Thank you!!

[@SimonSezIT]

Happy to help!

[@lisapenfold2979]

great video. thanks.

[@SimonSezIT]

Thanks for the nice comments, Lisa 😊

[@magtulunganpinoy5597]

thanks soooooo much!!!!!

[@SimonSezIT]

No problem!

[@TVSCDN]

Thanks madam🎉🎉🎉❤❤❤😊

[@SimonSezIT]

Most welcome 😊

[@nikush1631]

Is the final module available for this online as well? Thanks for all that you do, starting a new job Monday and these videos are so helpful!

[@black90ify]

we are not receiving any e-mail to download the supported file . will you check this issue

[@bhavnakawa1299]

I have not received the support file either

[@athennasamelin425]

hii, if you don't mind, can I ask the reference you've used in Index Match (Market Research: Revenue and Profit for Popular Iphone Apps)? thank youuu

[@ianrobertson5128]

Do you do videos on Excel for Mac 365? These are fabulous but the Mac version is different in some spots.

[@SimonSezIT]

Thanks Ian, Delighted you are enjoying the tutorials and thanks for letting me know what you are looking for, we'll see what we can do: Our Excel for Mac Tutorials are currently beginner level:kzbin.info/www/bejne/qYq4ZZ5mhZ2Wa8k

[@z-spotinternational165]

I have subscribed to the excel file already but i dun see the work file being sent - its not in the spam folder either

[@prathyushasegu4991]

HI Mam, Can you share a vedio by using Unit price inplace of Part No.

[@hestiaa9354]

I don’t know if that will work. The unit prices might be the same for several items. How would VLookup know which one to select?

[@z-spotinternational165]

the file has not gone to any SPAM Sir... hope you are able to help out with this

[@hapemokenela7388]

i didn't receive an email for the download link. Please reply.Thank You.

[@SimonSezIT]

Please check your spam folder.

[@sandhyarani362]

will u make a video on excel 2007

[@SimonSezIT]

We do have some older tutorial videos on Excel 2007. Check out this playlist ➡️kzbin.info/aero/PLzj7TwUeMQ3gIjaQf5o75BrEeaSF2cg_j

[@dexxxxxxxx]

27:26

[@RY-ey7dx]

For some reason, the instructor files to follow along are not accessible. the link returns a blank webpage :(

[@SimonSezIT]

Hi RY. Sorry about that. Please try clearing your cache or try another web browser.

[@RY-ey7dx]

@@SimonSezIT thanks.

[@ememanduquincy8457]

Can you make include timestamps to such a long video?

[@SimonSezIT]

Thank you for the feedback, we'll see what we can do.

[@idowumayowadavid886]

Please I really wish to get access to the file promised in the video. I have given my email details but I am yet to receive any file.

[@idowumayowadavid886]

Thanks alot . I just received the file for free.

[@aradhyarathi2048]

Please send the document of VLOOKUP true statement for practice in my reply.

[@SimonSezIT]

You can download the instructor files for this video here: www.simonsezit.com/excel-biz-analysis-instructor-files/

[@aradhyarathi2048]

@@SimonSezIT Thank you !!

[@aydaneliyeva4682]

why doesnt work file?(

[@dessleonid]

Nope I didn't get the result of 57 and 52 but 100 and 100 on those cells while doing your shitty match + vlookup. Why? This is BS. Why do you need this complication with match formula while just Vlookup formula manages its work pretty damn good of its own accord?