Vlookup Excel Best 

You just saved me a few million years of copy/pasting and I've sent this to my coworkers. THANK YOU!!!!!

AMAZING- Searching several videos for weeks on this- best one and will definitely forward for new hires to begin referencing ! Thank you!!!!

best example of vlookup I have come across. It is clear concise and not trying to mystify . Thanks

this is the most simple way anyone has ever explained it now i can continue with my work

absolutely the clearest example of a vlookup. I have looked at several videos and this has helped me SOOO much! THANK YOU

Thank you for your video! I cannot imagine at this point how much easier you've made my life! Thanks!!

Finally someone who can explain it in simple plain English. Thank you for sharing this.

This is really the best video I've seen on this function, owing to the minimal size of lookup table. What else makes it better is that the demonstration uses a simplified example as opposed to a more complex, specialized 'real life application'

The clearest, most concise example of vlookups I have seen. Great work.

Thank you! Ignore all the rude comments. I'm a beginner so I appreciate the intro. This helped a ton! Thanks again.

First time I have been able to follow instructions and create my own V and H lookups. Thank you

I've been searching high and low for a good video that clearly explains vlookup and this is it. Thank you for the great explanation! I'll gladly recommend this one to other friends

I have been trying to use vlookup for months now... Microsoft should find a way to promote such kind of videos, otherwise it is impossible to solve such functions by reading help etc. Thanks alot, very useful and I started using it right away in 5 mins..

thanks this understandment got me a $20/hr internship (:

I actually really appreciate the intro to this

Jalayer, you are a lifesaver! Thanks to your clear explanation and video I was very successful in doing vlookups of massive spreadsheets! I cant thank you enough!

Thank you so much! You explain it nicely. I watched many of the vlookup videos and all of them are hard to understand. I really appreciate your effort by posting videos.

This was the best video. Very clear and it is the 2011 Excel version! Thanks! I understand it so much better now!

Wow the only tutorial that helped me achieve what I wanted to do. Highly recommended.

Hi buddy thanks a lot mate I have gone through about 5 to 10 videos on RU-vid for the Vlook up but none of them was able to clarify it as much as your video it was amazing now instead of cramming what Vlook up is I was able to understand what is vlook up and what's its use. Thanks again mate

This is a simple and short video. Easy to follow. Good job!

i was searching for vlookup in web at many site. But i could not understand, you are great, U teach me very simply. thank you very much, appreciate it

Awesome vid. simple and clear enough to understand the logic, what my $300 business book couldn't do. Greatly appreciated, thanks !!!

You saved me. This is the only video that helped make sense of what I was trying to do. Thanks so much:)

In my opinion, Jalayer Academy is the best Excel teacher in RU-vid site. Thanks.

Thank you!!! This helped me finally understand VLOOKUP.

as soon as you said vertical lookup it wrapped it up nicely. Thanks

The best explanation I've seen, thus far!!

I have to ditto what others have said below. This is the best well explained video that I have come across. Awesome job!!

The first half was a little long, but for a novice who wants to know why you are doing what you are doing, I think it helps a lot As for showing how the actual function works, thanks for making this video! You've helped me with a portfolio my university hasn't given clear instructions for nor much help with for people less computer-savvy

Thank You. Much Appreciated. Have seen many videos but your one explains the best.

You're a fantastic teacher! Thank you so much!

One of the best clip for learning V lookup basic function. Worth watching

Thankyou for the help. You made it very simple and easy to understand. Thanks a ton.

Boss you are brilliant!!! Best way to teach! Thanks for showing me VLOOKUP

Great Video. Exactly what I was looking for. Simple and straight to the point. I got my spreadsheet working like a charm. You saved me a lot of work. Thank You!!!

Thank you forever and ever for your video!! It helped out a LOT!!!! Thanks again!!

Thank you soo much!!! You really made it very easy to understand..Great job done!

Great video! Btw. your voice reminds me of Ross (David Schwimmer) from "Friends" :D

This was extremely helpful. I love how you made it so simple. I watched another vLookup video but this one made it clearer for me. Thanks!

Thank you very much! The most concise and easy-to-follow video on this function for all of us who rather dread Excel. P.S. I think you are a better Ross-version, your voice doesn't actually want you to fall asleep. :-)It's more upbeat You kinda look like him though! :-)

Great video.. and very well explained. I love the way you teach/train. You are the only one I came across so far that explains it and I understand it now. Thank you!

Yay best video EVER finally can understand the damn VLOOKUP function thank you Jalayer

Simple and coincise, I will hook up to more videos. I will be unfair if I refuse to share, recommend and enjoy it again and again with friends. I am greatful.

thanks dude tommorow is my exam and u hav really saved my life...

Thank you so much! I was struggling with this for hours before I found your video

great tutorial, simple example that can be manipulated to complete a more complex or advanced vlookup...thanks!!!!

Hi rdjalayer ---Thank you very much for your help with VLookup. Great that you are willing to help others. This Vlookup tutorial was very well done, well explained, and very helpful.

vlookup is a useful function, glad the video was helpful to you

You're a saint! Finally I understand! Thank you thank you!

Thanks for this easy to learn video! Just helped me at work a ton!!!!

Excellent example! This just helped me out tremendously! Thanks

The interesting thing is that I've taken entire college courses dedicated to Excel and Office as a whole and none of them explained this topic as quickly and as precisely as you did.

thanks for this video, watch it everytime I forget how to use vlookup

This video is the best, I checked many of available. Even I understood!!!

Thanks! I learned. Going forward, avoid unnecessary explanations.

Thank you for explaining it in a easy way!!

Worked like a charm... thanks for taking the time!

Thank you so much, best video so far on vlookup

You saved me!!! Thank you so much please keep up the good work!

Great video! Nice simple approach to explaining the fundamental use of lookup. Thank you!

u r a good teacher. Its easy to understand.... thank you :)

It really helps...really. Thanks a lot for making it simple to understand

You are a good teacher. You explained it very well.

Great presentation. Your voice is very soothing.

Thank you. I like that you teach us to type in the fuction insted of rely on the insert function dialog box. Your way is much faster.

"Absolutes" means a "$" sign. You can fast forward to 4:23 to start learning this. You can increase the speed to 1.5 as well.

hello mr jalayer i would thank u for helping me in my exams i am very happy that u helped me sir thank you!

the best video on vlookup I have found thanks

The Best Best Best simplified explanation ever.

Holly shit......this tutorial was miracle from the beginning!

Simple lesson but just what I needed !! Thank you for your effort

Thanks,I found it easy to follow -it was exactly what i needed . Well done malc UK

I am glad I could help. Thanks for the comment.

Short, sweet and to the point, very understandable. I've seen a few videos about vlookup, they were also good, but too wordy, too long and I found myself really not understanding after watching it for over 30 minutes.

Hey thanks for spending your time on this video, really easy to absorb 😊

Omg thank you!! I was struggling for a while with this and your video was perfect. :)

Very easy to understand even my English is not great. Thank you so much.

I love you video it was so helpful for me ...thank you so much.

Hello! this was very helpful.!! I appreciate that you took your time to help us out!! Thank you =)

Beautiful. You saved me hours of meaningless plugins of numbers. Thanks!

Hi Jalayer, I have enjoyed watching your clips. You do have a calming voice something that we need when we are getting frustrated with Excel. I was hoping that you might be able to help me set up a school marking sheet. I want to be able to use letters ranging from E- to A+ in columns then in the last column they get an average. This is the short version of the problem if it is something you can help with I can go into more detail. Cheers Rod

Best Tutorial ever, Super easy :) Thanks

Thanks Jalayer, your lesson really valuable.

Cool. Just what I needed. Making up stock trading strategies on Excel and dealing with large data-sets. This really helped. Cheers mate.

Thanks a Lot Bro.So simple it was.Great.

thanks for the comment, glad it was helpful

When you first click with the mouse to reference a cell you can click the F4 button on your keyboard immediately after to get the $ signs around your reference and hence make your reference absolute.

Thanks for keeping it simple, will watch your other videos.

Dude, thank you man. this definitely was the best video as you had said in the title. cheers!

Thanks for posting this video. This is extremely helpful.

thanks for the thoughtful comment, glad I could help

Thanks man, it works for me, hooray! finally, a eureka moment. Really well explained for a beginner like me.

Thank you for the thoughtful comment, I am glad I could help

Thank you for the video... It helps me to resolve my problem and save many times.

Hey thanks man, this video really helped me understand how to use that darn thing!! Just in time too for my project is due soon, anyways thanks again!

Though the prelude is a bit extended but the way you did it is outstanding, thanks for sharing what you have

Thank you, it help reinforce what I am looking for.

after you click with the mouse to produce a reference in the formula bar, click "F4", this produces the Absolute "$" around the reference, then keep clicking "F4" to cycle through all the variations

no prob, glad I could help, thanks for the comment