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
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'
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!
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..
Hi buddy thanks a lot mate I have gone through about 5 to 10 videos on TH-cam 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
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.
arlene wilson - yes, because he explains it and you have some people getting mad at him for being detail and explaining why, etc. I think is training is great!
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
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!!!
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!
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.
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.
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! :-)
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.
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.
What is the name of the video you refer to around 7:00... about doing a vlook up on numbers that are not exact. Also can the returend value be words that are color coded?
You just saved me a few million years of copy/pasting and I've sent this to my coworkers. THANK YOU!!!!!
Finally someone who can explain it in simple plain English. Thank you for sharing this.
First time I have been able to follow instructions and create my own V and H lookups. Thank you
AMAZING- Searching several videos for weeks on this- best one and will definitely forward for new hires to begin referencing ! Thank you!!!!
+LaToya Jones thanks for forwarding
Thank you! Ignore all the rude comments. I'm a beginner so I appreciate the intro. This helped a ton! Thanks again.
best example of vlookup I have come across. It is clear concise and
not trying to mystify . Thanks
absolutely the clearest example of a vlookup. I have looked at several videos and this has helped me SOOO much! 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
Thank you for your video! I cannot imagine at this point how much easier you've made my life! Thanks!!
The clearest, most concise example of vlookups I have seen. Great work.
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'
This was the best video. Very clear and it is the 2011 Excel version! Thanks! I understand it so much better now!
this is the most simple way anyone has ever explained it now i can continue with my work
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!
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..
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 TH-cam site. Thanks.
I have to ditto what others have said below. This is the best well explained video that I have come across. Awesome job!!
Awesome vid. simple and clear enough to understand the logic, what my $300 business book couldn't do. Greatly appreciated, thanks !!!
Hi buddy thanks a lot mate I have gone through about 5 to 10 videos on TH-cam 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
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.
arlene wilson - yes, because he explains it and you have some people getting mad at him for being detail and explaining why, etc. I think is training is great!
One of the best clip for learning V lookup basic function. Worth watching
This is a simple and short video. Easy to follow. Good job!
Thanks a Lot Bro.So simple it was.Great.
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
Wow the only tutorial that helped me achieve what I wanted to do. Highly recommended.
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
Boss you are brilliant!!! Best way to teach! Thanks for showing me VLOOKUP
I actually really appreciate the intro to this
Yay best video EVER finally can understand the damn VLOOKUP function thank you Jalayer
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!!!
The best explanation I've seen, thus far!!
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!
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!
Great video! Btw. your voice reminds me of Ross (David Schwimmer) from "Friends" :D
Thanks, you are the 3rd person who has said that. I have to look into this. haha
+krispy2flux Now that you said that I can't focus on the actual video lol just his voice!
For Christ sake... They were on a break!
Woods ...i fkn hated ross
very true!!
Thank You. Much Appreciated. Have seen many videos but your one explains the best.
You're a fantastic teacher! Thank you so much!
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.
Thank you so much! I was struggling with this for hours before I found your video
Thank you!!! This helped me finally understand VLOOKUP.
Thankyou for the help. You made it very simple and easy to understand. Thanks a ton.
Thank you soo much!!! You really made it very easy to understand..Great job done!
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.
as soon as you said vertical lookup it wrapped it up nicely. 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! :-)
"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.
You can watch th-cam.com/video/aF6UYzmiF6E/w-d-xo.html as well
Dude, thank you man. this definitely was the best video as you had said in the title.
cheers!
Great video! Nice simple approach to explaining the fundamental use of lookup. Thank you!
Cool. Just what I needed. Making up stock trading strategies on Excel and dealing with large data-sets. This really helped. Cheers mate.
7 years ago, hope this guy bought TSLA
thanks dude tommorow is my exam and u hav really saved my life...
Hey thanks for spending your time on this video, really easy to absorb 😊
You are a good teacher. You explained it very well.
You're a saint! Finally I understand! Thank you thank you!
I am glad I could help. Thanks for the comment.
great tutorial, simple example that can be manipulated to complete a more complex or advanced vlookup...thanks!!!!
Thanks man, it works for me, hooray! finally, a eureka moment. Really well explained for a beginner like me.
Simple lesson but just what I needed !!
Thank you for your effort
Omg thank you!! I was struggling for a while with this and your video was perfect. :)
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.
You saved me!!! Thank you so much please keep up the good work!
Worked like a charm... thanks for taking the time!
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.
Thank you. Very helpful and easy to understand. This will help me a lot!
Excellent example! This just helped me out tremendously! Thanks
Thanks,I found it easy to follow -it was exactly what i needed . Well done
malc UK
thanks for the thoughtful comment, glad I could help
thanks for the comment, glad it was helpful
vlookup is a useful function, glad the video was helpful to you
no prob, glad I could help, thanks for the comment
Thank you for explaining it in a easy way!!
Thank you so much, best video so far on vlookup
Great presentation. Your voice is very soothing.
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!
no problem, glad I could help, be sure to check out my other tutorials, over 200 to choose from my channel
Thank you for the video... It helps me to resolve my problem and save many times.
thanks this understandment got me a $20/hr internship (:
u r a good teacher. Its easy to understand.... thank you :)
It really helps...really. Thanks a lot for making it simple to understand
This video is the best, I checked many of available. Even I understood!!!
Good job bro, I was asked in interview about this V look up. so thank so much! keep up the good work
Best Tutorial ever, Super easy :) Thanks
Thanks for keeping it simple, will watch your other videos.
Thanks! I learned. Going forward, avoid unnecessary explanations.
hello mr jalayer i would thank u for helping me in my exams i am very happy that u helped me sir thank you!
Thanks a lot. God bless you for an excellent video. U cleared my doubt completely.
Thanks again Bro!!
+Komal Talreja hello baby hower u.
looking so nice i love u.
Babee you are hot. Will you marry me?
Please say yes.
yes why not. i will marry with u. if u r true girl.
+Komal Talreja I like your photo. Please marry me babe.
your welcome, thanks for the thoughtful comment
The Best Best Best simplified explanation ever.
Hello! this was very helpful.!! I appreciate that you took your time to help us out!!
Thank you =)
the best video on vlookup I have found
thanks
thanks for your thoughtful comment
Thank you for the thoughtful comment, I am glad I could help
thanks for the thoughtful comment
Thank you for your video! It is very helpful and easy to understand:)
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 Jalayer, your lesson really valuable.
thanks for this video, watch it everytime I forget how to use vlookup
Very easy to understand even my English is not great. Thank you so much.
Beautiful. You saved me hours of meaningless plugins of numbers. Thanks!
What is the name of the video you refer to around 7:00... about doing a vlook up on numbers that are not exact. Also can the returend value be words that are color coded?
Thanks for posting this video. This is extremely helpful.