VLOOKUP in Excel | Tutorial for Beginners

In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel. With VLOOKUP, you can find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

👋 Additional resources:

⌚ Timestamps
0:00 Introduction
1:47 Organize data properly for VLOOKUP
5:38 VLOOKUP Exact match
9:34 Improve error message with IFERROR
11:10 VLOOKUP Closest match
14:48 VLOOKUP Across sheets
15:43 HLOOKUP
18:21 XLOOKUP Simple example
22:53 XLOOKUP Combined with other functions
24:54 XLOOKUP Returns an array
26:42 XLOOKUP Match modes
28:30 XLOOKUP Search modes
31:24 Wrap up

📃 Watch related playlists and videos

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎁 TOOLS AND DISCOUNTS

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #vlookup #excel

[ExcelEssentials_]

Pro tip! In addition to 02:55 - When you have a spreadsheet with a lot of columns, the column with the lookup value does not have to be the first column. Just make sure that the column with the lookup value is left of the column you want to search in. The Vlookup function can only search to the right!

[christopherjames]

Dear Kevin, I just stumbled upon your video and I must say that you are gifted with the skill of explaining concepts and making them so easy to understand and apply. Today I only go to your youtube videos for all things excel. THANK YOU for making an impact in the lives of so many people!

[Montpelier-sama]

32 minutes well spent. At first I felt that this was something I will have a hard time learning while working in the Real Time Analyst and Workforce Management team. But you made it look so easy to understand. Two thumbs up and you earned a sub.

[FirdausIsmail]

thats right kevin. he knows im a baby and easily got confused. glad he held my hand throughout this tutorial lol

[sunonymous]

I used to do v-lookups a lot years ago and I’m quite rusty. Your video helped a lot. It came right back to me. I have an interview on Monday where I have to do this…and I feel super confident now. Thanks!

[alexmanzonelli]

Your vlookup tutorial is top notch. After watching and following along with a dozen of my own spreadsheets it’s finally sinking in. I’m so grateful to you.

[custeinrobinsonmukono]

This my friend is the most productive 30 minutes I've had all day, thank you!

[davido]

I don't have to use VLOOKUP very often but when I do I always come back to this video. Thank you for your easy to understand guide!

[JeevanBManoj]

Pure gold. 32 minutes well spent if you want to learn how to look things up and join tables in excel

[rosehuang]

you are an absolutely amazing teacher!!! Really appreciate your time putting these all together. Super helpful!

[raphsenyoke]

I love the way you always make sample files available

[vikasarsid]

These teachings have huge impact on any working proffesionals man, thank you for helping out ❤

[Reed]

Thank you so much for this thorough tutorial!! In one afternoon, I've gone from being clueless/intimidated by these functions to feeling empowered by and confident to use them!!

[SK-bvyd]

OMG! Your tutorial is the easiest to understand! So thankful for all the time and effort you put in making this video. Looking forward to getting more comfortable with excel learning from you.

[caoimheg]

Thanks for this in depth video! I start a new job tomorrow and was asked about vlookup in the interview (thankfully that wasn’t a special requirement of the position) but now I know the right answer would have been “Xlookup is a better function “

[Paul-in-Viet-Nam]

Thank you for this video. I'm not too bright and your voice made it possible for me to watch this enough times for an old man to understand. I really appreciate your work.

[r.d.martin]

Fantastic video. You really should be a teacher/professor. You take a subject that can be daunting and break it down into very consumable steps. Thanks for your efforts.

[Evenizer]

Muchas gracias Kev por el apoyo. Honestamente, me quedé confundido a mitad del video en los Xlookup, intentado decifrar cómo usarlo en situaciones cotidianas para mí. Sin embargo, estoy seguro que los sabré aplicar después. Esto me ha servido bastante. ¡Muchas gracias!

[StephanAshkenazy]

Thanks a lot, dear Kevin! Your videos are very clear and are providing a lot of information!👍

[lopeslayer]

My dude, more than 10 years and nobody explained VLOOKUP to me in a way to not get any bugs! Thanks a lot!