VLOOKUP in Excel | Tutorial for Beginners
Ғылым және технология
🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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:
- Sample file to follow along: 1drv.ms/x/s!AmxrofZZlZ-whK4bP...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ 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
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | shopify.pxf.io/XY9rPa
✅ 📋 Notion | affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZread
kzread.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz
⚖ 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
Пікірлер: 610
🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com ⏭ Watch more free Excel tutorial videos: kzread.info/head/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 In-depth Pivot Table tutorial: kzread.info/dash/bejne/gph-3NtyZZndn5c.html
@BunnyPranav
3 жыл бұрын
Kevin, why dont you sign up for a verified BAT creator in brave browser so ppl can donate to you from the bat that they earn just by getting ads as notification
@gravelcityorder3767
3 жыл бұрын
The videos I have watched so far are so informative! You explain everything so well. Thank you for putting in the work to create these.
@koklinda5406
2 жыл бұрын
LlllDert
@koklinda5406
2 жыл бұрын
Dert
@koklinda5406
2 жыл бұрын
Dortoorhtevet
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!
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!
@AdhamMGhaly
7 ай бұрын
Thank you. I have been confused by that because even official Microsoft Training Materials state that the column MUST be the leftmost one, yet when I tried it out with other columns it worked normally.
@KNg-pt8wf
5 ай бұрын
Don’t think you have to sort the search column either.
@susanagween432
4 ай бұрын
This was actually the reason I looked up this video. LOL
thats right kevin. he knows im a baby and easily got confused. glad he held my hand throughout this tutorial lol
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.
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.
I really like the way you clearly and concisely explain everything. I also like the tempo at which you explain how your examples work. Not too fast and not too slow. I just wish your examples were a little more complicated but at the end of the day, it probably doesn’t matter as long as I learn how the function works. Thanks for all the videos! I’ve learned a lot from your channel.
Pure gold. 32 minutes well spent if you want to learn how to look things up and join tables in excel
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.
This my friend is the most productive 30 minutes I've had all day, thank you!
Your videos are great. This seems like a natural progression towards either getting user input in Excel for lookups or creating databases with MS Access. Edit: I mainly use Pandas but I can now appreciate the benefits of using Excel, especially after your Power BI video.
you are an absolutely amazing teacher!!! Really appreciate your time putting these all together. Super helpful!
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!
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!
@JaneParkerBowls
2 жыл бұрын
How did U go?
i love how the way you teach. i have zero knowledge in vlookup, hlookup, and xlookup, yet you explain it to me like I know it too well now. Great job!
hi, Kevin! Thank you so much for giving us tutorials for Office and Windows. That means a lot! Stay safe and stay healthy!
Thank you very much indeed for this upload, Kevin. I recently moved career from a Government agency that did not allow external apps so when I started in the new company my Excel skills were pretty basic. Thanks to your uploads! I've up-skilled to a point where I'm very comfortable within a short period of time.
I've looking for a video that goes in-depth into the LOOKUP formulas and you nailed it! Wish this was around when I was in college because my professor was terrible at explaining how these formulas worked! Thank you so much for making such an informative and thorough video that's easy to follow!
These teachings have huge impact on any working proffesionals man, thank you for helping out ❤
I was struggling with a data analysis project that required several formulas. You literally saved my life !!
I never thought of having this excel turorial before, watching this video help me a lot on my technical exam during my employment application. And I got a job! I thank a lot with this tutorial video provided. Thank you so much Kevin Stratvert.
You’re on a roll! Every time I see your videos I learn lots of interesting ways to do things. In this case I knew about these functions, but never knew the nuances and that clicking fx brings up a nice window to keep you fill out the functions.
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 “
Thanks, I wanted to learn the function of V-LOOKUP for many days, and this video helped me in that only, Also you explained how to use H-LOOKUP and X-LOOKUP which I didn't know before, but after watching this video I understood how to use it & in which situations it can be used. Thanks Again!!😁
My dude, more than 10 years and nobody explained VLOOKUP to me in a way to not get any bugs! Thanks a lot!
Awesome Tutorial Kevin! I needed a refresher and this was perfect! Easy to follow and you explained in detail while provided an excel spreadsheet with data to practice! I'll continue to follow.
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.
@yaseminyalcn4055
11 ай бұрын
I think he is a A.I.
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.
Fantastic tutorial! Reading a book didn't help me understand anything about this but you make a valuable video that's very easy to follow along. Cheers Kevin.
Your tutorials are the BEST I've ever tried. I think I now FINALLY get VLOOKUP !! Thank you sooooooo much !!
The workbook was great to work through. I would pause the video after you covered a section and go to the workbook to try to do all the steps on my own. Very helpful thank you for including it Kevin :)
I SUPER LOVE THAT YOUR TUTORIALS COME WITH SAMPLE FILES.
Thank you Kevin. You really made me understand the whole concept in one big bite. You are a good teacher
Thank you so much Kevin. This has been my nemesis for years. No longer!
Thank you so much you're an amazing trainer. I used to work for MS years ago in Irving, TX as Active Directory Support Engineer.
Kevin! you are gifted with great ability of teaching in the most efficient way. Thank you so much for being Kevin!
Hi Kevin. I hv just watched your video today and I'm more than impressed with your skills. Please dont stop this channel, you have a lot to offer to this world
Thank you so much Kevin! I always revert back to your videos. Very helpful, straight to the point, and informative! Thanks for sharing ☺
Excellent video. The best I have seen. I have been using vlookup but sometimes it is a struggle when things get a bit complex. I never thought about xlookup until your video. Now I am using it all the time. I am even going back to some excel sheets that I made with vlookup and changing them to xlookup.
Right when I needed this! My employer wanted from me to extract data from some messy xlsx files and as I didn't know anything about vlookup / xlookup, I watched many tutorials, but this one is by far the best one. Now I understand. Thank you
what a great teacher you are, super appreciate your effort on breaking down and easy to follow. thanks a lot
Brother thanks a lot, you finally allowed me to understand how the lookup tools work in Excel - you literally saved me an hour of grinding with this, thanks bro!
I love the way you always make sample files available
@KevinStratvert
2 жыл бұрын
Of course! Makes it so much easier to follow along.
@Kevin Stratvert, your videos are so helpful. You are a champion!
Thanks Kevin! Informative as always and the info is really useful! Just the basic concepts in 30mins!
I can't Thank you enough for this video. In my last job (that I didn't get) they asked if I knew what a VLookup was and the last time I did this was in 2008. Fast-forward through COVID. Since then I bought a Google Chromebook and have forgotten how to do this. Kevin, Thanks again for this video. It will aid me in my current job search.😀
THANK YOU, THANK YOU, THANK YOU. I definitely did not understand in my IT class and this helped me so much.
Hi Kevin, thanks a lot for explaining these functions. It was kind of mystery to me half an hour ago. I was not understanding the vlookup function, and didn’t know the xlookup one. Thanks to you I feel prepared to use these in a daily basis! You’re an amazing teacher!
Clean and simple explanation. Thats what I "lookup" for.
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!!
Hey Kevin! Thank you so much for this video. It really helps me to understand the Lookup functions better!! Your videos are the best. Keep up the good work 😍🤩🤩
i personally i love Kevin's tutorials. Continue doing good job brother
Thanks Kevin, I finally get it after struggling for some time. I appreciate your tutorial!
You are amazing man!! Thank you very much for the great content. I am definitely a subscriber. You got yourself a new follower. Thumbs up.
best teacher ever. Thank you KEVIN
"Hey Kev" the great thing about what I saw on this tute is you gave a brief disciption of yourself with no glowing resume like every other so-called tutor on youtube, Those that teach guitar, Piano,woodworking car repair what eve,r you let your knowledge and delivery skills tell your back story top stuff
I needed this for my school work, thank you kevin.
Thank you for taking the time to post and create this video. I’ve been working with more data lately and this is definitely something I’m going to be using going forward.
You may have just helped me land the job I've been wanting for a long time!! Now I can impress my boss..woohoo!
THANK YOU!!! I was struggling to learn this function until I saw your video. You are an excellent teacher!
You are an amazing blessing to this universe! Thank you so much, Kevin!
Wow - this was a full lesson on how to use v-lookup thanks, Master Kevin.
Where have you been all my life!!! Xlookup!!! Thank you Kevin 💞🙏
thank you! straightforward, easy to understand. Very Helpful
This video and the ability to follow up with the sample file is very helpful! Thanks a lot!
Thank you for doing this video! This made matching phone numbers I called to names in my contacts much easier!!
You explain things so clearly and make it easy to follow. Thank you so much!
Great video thank you. VLOOKUP changed my life many years ago.
@KevinStratvert
2 жыл бұрын
Amazing!
Thank you Kevin for this golden stuff in such a simple manner
Dear Kevin...So glad I found you on You Tube. I needed help with Pivot Tables and V Lookups (or as I know now) X Lookups. Thanks for all you do!
Kevin, thank you for all your clear and informative tutorial, it is one of the best, if not The Best out there, I am going to binge watch all of them - thanks a zillions!
Kevin, thanks a lot for this video. It's very simple to understand. It'll help a lot of people.
First time I’ve ever gotten a vlookup to work. Thanks to you!
Kevin, Thank you. Your explanations are superb. I hope you keep up with your good work from which, I am sure, thousands of people benefit. All the best always.
Kevin, thank you so much for these amazing video. You made it so easy to understad these useful formulas. Kudos, Kev.
. Hey Kevin I really was impressed by the way you explained these Excel functions and made it really easy to follow. Don't know whats its worth but just gain a new follower. Thank you so much
Thank you Kevin for this golden stuff in such a simple manner with example
I always forget how to use vlookup very soon. Each time that happens I come back to this video and voila :D I remember again! :) thanks Kevin
man I've watched videos in my language and none of them makes so much sense like yours :) Thank you! Keep it up
KEVIN!!!! YOU'RE THE BEST!!!! THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK
hey Kevin, i have an it exam tomorrow and its on excel and I think this is going to really help. so thanks! :)
Thank you so much! This is one of the best tutorials I’ve seen
Thank you so much Kevin, this is what I need for my report, you're amazing!
The best so far. Some videos are just overwhelming. Thank you so much for this!
This is the best tutorial on Lookup functions. Thank you!
Hey Kevin, your explanation was best among all the videos I watched. Thank you for your efforts.
Bro, thank you so much! I had a crazy amount of data that I had to manage and you have made it much easier!!!
Excellent Kevin, very very helpful and brilliantly delivered ,, thank you
Amazing Tutorial with the Sample File to follow. Nice and clear explanation. Thank you so much !
Even after all these years, a very informative video. Thanks.
Excellent course, thanks Kevin.
Excellent teaching ! I don't feel as novice after seeing your video .
Thank you for the video. I'm older and new to this. I'll definitely keep watching and learning. Good job!
Hi Kevin, your videos are ammazing. Thank you for being a blessing to many poeple like myself. I just stumble into your videos and i must say you are good teacher. Please Kevin i like you to also touch topics like PC or computer skills, MS office Excel and access. Thank you
BEST tutorial i have ever found! Good job Kevin! keep it up!
Thanks Kevin! appreciate providing the spreadsheet for us to follow and practice : )
This video is so effective and simple enough to understand. Thank you.
This is the best explaination of these functions I have ever seen. Thank Kevin
Thinking that we are improving our Excel skills by your daily Videos 👍👍
Great teachers, thank you Kevin.