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

✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩

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

✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩

Check out our Excel 2021 tutorials for beginners playlist here

Check out our FREE 300+ hour training course playlist here ➡️

💻Watch more popular tutorials from Simon Sez IT:

✅Microsoft Office 2021 and Office 365 Training Tutorials playlist

✅Microsoft Office 2019 Training Tutorials for Beginners playlist

💬Stay in touch!

🔔Subscribe to our channel:

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

[realHAUTEcre]

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!

[realvirtualdemand]

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

[cliffordeaton]

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

[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

[genesisfincorp]

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

[idowumayowadavid]

Thanks so much . I just received the file for free

[nikush]

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!

[bhavnakawa]

I have not received the support file either

[blackify]

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

[ianrobertson]

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

[z-spotinternational]

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

[z-spotinternational]

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

[athennasamelin]

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

[RY-eydx]

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

[prathyushasegu]

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

[hapemokenela]

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

[idowumayowadavid]

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.

[aradhyarathi]

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

[ememanduquincy]

Can you make include timestamps to such a long video?

[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?