Microsoft Excel VLOOKUP Tutorial

MORE INFO AT http://599CD.com/XKF4XV - Learn how to look up values in Microsoft Excel using the VLOOKUP function

Category:

Science & Technology

Tags:

• microsoft
• excel
• vlookup
• tutorial
• lookup
• computer
• excel training
• excel course
• excel for beginners
• excel help
• excel videos
• excel lessons
• excel classes
• excel tutor
• excel for dummies
• excel seminar
• excel tutorial
• excel tutorials

[Okay98]

Wow, this has to be the best vlookup tutorial I've seen around, others can be quite confusing because they don't explain it properly, thanks a lot!

[599CD]

@Okay98 Thank you!

[SuperBlaze999]

hello thanks for the vid but in v look ups when ppl put $ beteween the numbers what does that mean???

[599CD]

@SuperBlaze999 That's called an Absolute Reference. I have another tutorial that explains that.

[andre50203]

u can put the $ to absolute. so u can drag down without any problem

ex :=vlookup(B3,$A$9:$B$13,2)

thankss

[hungrycollegekid]

Thank you!!! I owe you a beer!!!

[MrJulke]

great video, easy to understand.. thx

[599CD]

@nhgh0208 I can't promise a speedy reply, but I'll do my best. I get a TON of email, so I don't always get the chance to help people directly here on YouTube. But, if you follow the link in the INFO sections above, that will take you to my web site where you can also submit your questions to me there.

[nhgh0208]

@jaketrogers Hey I need a little bit of advice on vlookup but am fairly green to the internet highway. Are you the person giving the tutorial?. If so can I ask you for some advice? If not can you tell me how to get a response for my questions? I can't seem to get past other peoples blogs, call me a dumbass but any advice would be good.

[vcodio]

Great Vid... I am having an issue where only part of the data populates. I.E I have two files one with 5000 records and an other with 200 records. I need to match some of the fields, however, only about 125 are updating. I am certain all 200 records should be available. I have converted the unique indicator by copy/multiply by 1..... what am I missing? Thank you!

[Jetrothull]

@Frankthetank23

thank you, your tip is helpful.

[drew202k]

great video

[iibi1367]

Great video. I also found this tutorial and article on Vlookup and pivot table very helpful

tutoraccounts.blogspot.com/201­­1/10/microsoft-excel-2007-tip­s­-and-tricks.html

[brettlee2010]

Such a polite way to teach. May Allah bless you & show you the right path :)

[MsNJohnson]

Excellent video!!!