How to use the VLOOKUP function in Excel

Learn how to use the VLOOKUP function in Microsoft Excel. This tutorial demonstrates how to use Excel VLOOKUP with an easy to follow example and takes you step-by-step through the different options when entering your formula.
VLOOKUP Function (and sample data):
www.techonthenet.com/excel/fo...
Excel Tutorials:
www.techonthenet.com/excel/in...
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: www.techonthenet.com
or follow us on:
Facebook: / techonthenetcom
Twitter: / tech_on_the_net
Pinterest: / techonthenetcom

[@Techonthenetcom]

Learn about the next generation lookup function in Excel called XLOOKUP: kzbin.info/www/bejne/d2HNfZh_fMSjgLs

[@nichualtaf]

Excellent, Thank you

[@samiacampbell1792]

This video explains in 3 minutes what all the other videos do in 20+ minutes!

[@MahmudShuaib]

what she said!

[@premaaskitchenhealthtips2823]

Good

[@Umopuns]

That’s why i clicked lol

[@ansoor123]

Exactly!!!!!

[@nikolaiedwards1096]

I am here because of school and I was just saying that to myself

[@PV-free123world]

I love these videos because they're brief and to the point. No taking 20 minutes to spit it out!

[@anonymously_me1803]

Thank you! I HATE those videos!

[@nuwarisharamujanet4454]

Just great and precise 👍

[@BanditosLair]

This literally just summed up a 35min course on courses in a couple of minutes

[@maddie9602]

Other videos _types up a table, painfully slowly_ This video: "what if we just already had the table ready to go and don't waste the audience's time?" Other videos: _explains basic info most people already know, repeats themselves five or six times_ This video: only explains what you asked for, trusts you to rewind and play again if you need repetition

[@iClone316]

This might be the most concise, easy to understand explanation of any Excel function created, in the almost two decade history of KZbin.

[@949surferdude]

After 4 videos this one was efficient on explaining the BASICS of Vlook up tables, thank you!

[@bitisha6792]

Same here🙂

[@XXsupermilocatXX]

This is literally one of the best how-to videos I've ever seen, thank you

[@alvinlloydbriones5640]

This is the kind of tutorial we needed -- straight to the point. I got exactly what I needed to know.

[@Trotsky1981]

Finally, someone who can actually explain this concept.

[@sudhirgupta16]

I've struggled my whole life for doing this and you just made it in few mins.... Kudos to you...

[@shampain5883]

Oh my god thank you so much, this taught me what my teacher couldnt in 2 minutes

[@soniamartell9220]

This was SO helpful! I spent way too much time trying to figure this out elsewhere... only 2 minutes & 57 seconds here. Thank you very much!

[@dishew]

Love this!, you explained it very simple and quick vs other long and complex ones in youtube thank-you! 👍🏽

[@njokuochafrancis3688]

I love your tutorials because you hit the point without waisting much time, please keep to this standard.

[@mahfuzarrahman8897]

I have watched more than 5-6 videos on Vlookup but they all were abusive. You have completely expained what actually Vlookup is. I many many thank you for your professional type tutorial.

[@danaemosley162]

Abusive haha I’m glad this is the first one I am watching

[@jamieyap6228]

Thank you for the quick, efficiently yet clear explanation!

[@briancarnell]

Thank you for explaining this so clearly. Very well done.

[@Techonthenetcom]

Glad it was helpful!

[@denayansaneh3523]

You're so awesome for this tutorial! Colleague at work showed me via teams but I had to delete the recording before I could look at it. You're tutorial is the exact info I need.

[@vivianbiondolillo3681]

A bit better than the other sources for Vlookup examples Much more articulate and that is what beginners need.

[@erikam5240]

Thank you for explaining well and getting right to the point.

[@erika30pinki]

Brief, clear, easy to understand. Loving this.

[@newvibes789]

You gave me exactly what I needed in 3 minutes when the other video I clicked on was going to take 30 minutes to do the same. Thanks for keeping it short and to the point!! Plus I can understand your English!!

[@adeleandrews4629]

thank you for being quick and straight to the point.

[@naokir.3649]

This video was super easy to understand and follow. I didn't watch the 25 minute + videos but this makes me wonder how they could possibly take so long to explain this

[@billgates6795]

This was perfect for my application at home; and I especially appreciate your explanation about the use of TRUE/FALSE.

[@davidanrewm2636]

Wow, the is the shortest most useful video I have come across on youtube. I found out exactly what I wanted to know within the first minute of the video. ❤️

[@CreoleGuh504]

I applied for a job that has a requirement for knowledge of vlookup and pivot tables. Thank you so much. Much easier than I thought

[@Techonthenetcom]

Great to hear!

[@Spydr..]

BLESS HER SOUL I HAVE BEEN TRYING TO UNDERSTAND THIS FOR TEH LAST 30 MIN

[@danv135]

Concise explanation, thank you!

[@yokokoko9748]

Jesus! I just spent 35 minutes looking around!!! Thank you so very much!!

[@LongLostYellowRanger]

I'm struggling with this damn course I'm taking at WGU and the course instructors suck! I learned more in this under 5 minute video than I did reading for the past 3 hours smh. Thank you!

[@clare534]

This is my current situation. The textbook is horrible as well.

[@Holu54]

Short and straight to the point. Gracias

[@shafrazbooso7232]

Simple Explanation.. No running around the bushes... Thanks...

[@cassandrap.3183]

I’ve been struggling with this function; couldn’t figure out what I was doing wrong. This video made it clear for me. Thank you!!!

[@bluestripes6037]

So, so good! Thanks for being concise and clear!

[@arabastian3771]

This helped me so much!! Thank you for posting!!

[@noumbissieleonel8778]

This is a very clear explanation!

[@aliaamalina7485]

Very clear explaination! Thank you so much!!

[@es358]

I rewatch this everytime I need to use this function. Thank you!

[@levellkinchen1]

THANK YOU! I now have a better understanding of VLOOKUP function in Excel.

[@TaranBhagat]

Very good teaching.Thanks for saving time & giving clarity.

[@kumaranshul742]

Nice, short, crisp and to the point. Thank you

[@jobharath2812]

So simple yet so effective as a small tutorial, thank you 🙏🏽

[@SinghalLouis]

Thank you so so much.. just so precise and exact explanation, a 5 year old would understand.. thanks a ton..

[@wonderland1492]

Thank you! I was not about to watch a 30-minute video on someone rambling about VLOOKUP when it can be explained in minutes.

[@shamans123]

Very grateful for this video. I was having a hard time understanding how to format this based off text guides.

[@wazmink2459]

short tutorial and very clear and easy to understand, through this channel , I learn and have made my series of excel practice of basic formulas and function. thanks and God Bless this channel

[@BloodySunnday]

Thank you very much! Straight to the point!

[@sohamchatterjee3363]

Thank you very much !! The most simplified way you have mentioned.

[@Timo_OB]

Thanks you random internet lady. You just made my week!

[@LadyALCO]

I appreciate the 2 min video explaining what this is!

[@linusnilsson2377]

thank you no long straight to the point and more understandble than all others.

[@simonmokgotla816]

Thank you for a simple and perfect explanation.

[@saadjamshed150]

I recently started new job and this really helped , thanks a lot

[@harismasood3793]

Excellent video and easy to understand. Thank you

[@lola0821]

Thanks! Very simple and to the point!

[@JRCurtner]

Quick and to the point. Thank you!!!

[@toxicwaste920]

I needed to learn this for my job. Thank you for explaining it.

[@Jam-BasFamily]

Ito tlga kilangan kong malaman. 😍

[@jasminrobinson7830]

Thanks for explaining in clear dialogue! Awesome teacher

[@Techonthenetcom]

Glad it was helpful!

[@testing123127]

Thank you. This helped me so much

[@AndresLeonRangel]

no wonder why many of my greatest teachers had the ability to compress information. Thanks to all my skilled teachers man and woman

[@JasTheKariol]

Important note: the data with values that the VLOOKUP looks into needs to be on the left side column, and the data from which the VLOOKUP will output a value needs to be on the right.

[@adogmcdizzle]

Thankyou!

[@MRobie-fe8hd]

thank you!

[@patricias5122]

A lot of people get that wrong....

[@christianornelas994]

dude why are you the first person Im hearing say this?? You just saved me

[@Sunokanse]

Thank you! No wonder it wasn't working!

[@ziaulislam5319]

Thank you. Such a useful and understandable video. I got my much needed solution.

[@idellasheart]

Easy to follow and understand, thank you.

[@monalidas6268]

Hi I am from India, was watching lots of video on v lookup but every time end up with NA. This video is really easy to understand and give the exact result

[@balvo]

gave me a lightning quick refresher in half of the video whilst I sat at my desk 😊 thank u!

[@Techonthenetcom]

Wonderful!

[@DROIDFARM]

Thank you for making the most of my time with such a awesome short video! Bravo 👏 liked and subscribed!

[@BeingEarnerPK]

Much Helpful Video 🥰🥰🥰 love from Pakistan🤚

[@GT-gp2nb]

Super helpful, THANK YOU!

[@jacobhardy2313]

short and consise. Love it

[@mackdennis7355]

THANK YOU, you were the only video helpful with this subject

[@Techonthenetcom]

Glad it helped!

[@mikevieira6041]

Thanks, you made it look easy.

[@jhrsln9119]

easy to understand for a beginner like me. Thanks!👍

[@itstwilight]

TYSM- this video helped aLOT! Thank you for explaining this so clearly.

[@Talkswithmargarita]

Thank you for this video! quick to the point and efficient

[@teresamaria6149]

You are a life saver! Thank you!

[@vermillion2297]

WOW THANK YOU SO MUCH 😭💖

[@mevoma]

Thank you very much. You've explained it very well.

[@popfan125]

Using this to help me with my BTEC PSA. Thanks!

[@pregret]

decades after college and ibank work did not help me recall how to use this. it's crazy. thank you so much for a helpful explanation to refresh the memory again!🤩 chatgpt isn't helping lol

[@akamnitzer]

This video is concise and exactly what I was looking for to quickly refresh my knowledge of VLookup. Keep up the excellent work!

[@Techonthenetcom]

Glad it was helpful!

[@starwolfd]

Thank you, you're such a life saver 🙏🏾

[@MademoiselleEse]

Thank you! You just made me save so much time.

[@vanillacaffelatte]

Thank you SO MUCH for such a helpful and QUICK video!

[@Techonthenetcom]

Glad it was helpful!

[@gauravsavlani5725]

thanks short and informative

[@AMindInOverdrive]

Lovely! Nice and straight-forward. No 10min explanations. I clicked Like!

[@khoai_ryan]

Many thanks, really appreciate!

[@karolinejimenez7488]

AMAZING video. I have been watching videos that are 10-30 mins long and this video explained it better and to the point! Your awesome! :)

[@govardhanj5113]

That was real quick info..thanks

[@mesharibuhadi1437]

Thanks!! That was extremely clear!

[@tahmed1870]

You made it so easy. Bravo.

[@kimjones8249]

Thank you. This was very helpful

[@JA030]

Thank you very much, really helpful!

[@abasmayor]

Thank you for this.

[@EricsBBQAndMORE]

Just what I needed, thank you!

[@delicious9930]

Needed this for an interview thank you! Such an amazing straightforward explanation

[@vishnuks5479]

Thank you so much. It helped.

[@bitisha6792]

Thank you so much after watching so many videos i still didn't get and after seeing yours one i got it💗thank you so much

[@Childofdarose313]

Thank you!

[@dhendroid2373]

Saved me a lot of time, Thanks!