This was a really great tutorial! The best part is the examples. Many others give you one example of how to use VLOOKUP, but this one gives you 4 good different examples. Great lesson!
This is an excellent tutorial! It's to the point and no nonsense. You won't believe how many other "tutorials" have lost my attention after the first 5 seconds with all the "ums" and unrelated babblings.
your video was very helpful! i was tired reading my excel guidebook without getting anything clear,instead i was confused. but your explanation and example was clear and it really helped! thanks!!
Thank you! Very well done. I was the same as fendergod1969...spent a while on microsoft site trying to figure out vlookup, spent time in forums, but your video was the simplest explanation.
Thank you for the tutorial. Was working on a "lab" for a class and i'm new to excel but for my major have to take this excel intermediate course. I probably should have taken the beginner course first =/
Good tutorial! However, the third example (bonus) should have used only one lookup table with three columns -- Year, Rank, Bonus/Pct. It will be more clear & easier.
This is one of the most valuable demo I ever see
THANK YOUR, YOU SAVE ME AFTER 4 LONG HOURS OF TRYING TO FIGURE OUT HOW TO USE VLOOKUP, THANKS
One of the finest video on Vlookup! The examples are great. I'm sure all your viewers will benefit. Thank you!
This was a really great tutorial! The best part is the examples. Many others give you one example of how to use VLOOKUP, but this one gives you 4 good different examples. Great lesson!
Your videos have been more helpful than ANY book/class that I've taken! Thanks for helping me get my MCAS certs!
This is the first time I've actually understood vlookup. Thanks very much.
This is an excellent tutorial! It's to the point and no nonsense. You won't believe how many other "tutorials" have lost my attention after the first 5 seconds with all the "ums" and unrelated babblings.
I'm a Technology Trainer and I think that was VERY well done. Kudos!
The world is a better place with people like u!
Fantastic! I was fiddling around with that function for 30 minutes and couldn't figure it out. After watching this took me 30 seconds. Thanks a ton!
Wow! I'm speechless! *standing ovation and hat's off to the presenter of this tutorial*
Excellent video! The VLOOKUP function was rather difficult to understand until I took a look at this. Thank you!
I needed help with the tests they use for temporary staffing companies. This has that and SO much more, thanks man!
this is a 5-star video on basic VLOOKUP! thank you SOO MUCH!
Thanks, I needed to figure out VLOOKUP and because of this tutorial I was up and running in 5 minutes.
Didn't know about F4 too, thanks!
OMG! I don't know you, but I now love you. I could not understand how to do this and then I did, in less than 30 seconds. Thanks to you. You rock!
You should know your a life saver, Ive got a computing exam tommorow your video is very clear and helpful.
This was crystal clear, relevant, and right to the point. Awesome stuff
very clear explanation. i'm currently reading a book and this has helped me to understand Vlook ups more clearly...many thanks
Thank you for such a nice video. You've made it so easy to understand first with grades then with some twists. It really is a blessing.
Just to let you know, I really enjoy every clip you put in. appreciate your time that you put on this
your video was very helpful! i was tired reading my excel guidebook without getting anything clear,instead i was confused. but your explanation and example was clear and it really helped! thanks!!
I already thanked you once, but here we go...Once again!! thanks for the wonderful tutorial!!
Great tutorial, thanks! As a C guy, the non-zero-based column indexes always get me.
You just got me out of an excel jam. I felt like I owed you an extra positive comment. Thank you!
Thank you! The books just couldn't get the point across quite like this demonstration.
Thats amazing tutorial, really clean...You must be a teacher or an expert in Excel..
Keep it up mate!!
Started writing a java program to do what you did... then saw your video tutorial and gave up programming :-)
tyvm
[paused] just before resuming.
I really like this 00:15 randbetween function. I've never heared about it before.
thank you :)
good explanation, you don't miss anything and its easy to follow
HOW YEA!!!!!! Thank you so much! It's now nearly 1h that I'm trying to do the same kind of thing with vlookup without any results! You saved my day ^^
Thanks much. Simple, direct to the point as what all training should be...
Hi,Ralph you are amazing teacher.I watched your excel videos and learned lot from it.Keep it up and help us like this in future.Thank you.
Thank you! Very well done. I was the same as fendergod1969...spent a while on microsoft site trying to figure out vlookup, spent time in forums, but your video was the simplest explanation.
thank you, you explain this very well.
I was having a problem doing this vlookup for my PC class in college but this really helped
Excellent tutorial on VLOOKUP. Btw for those Mac users, like myself, the absolute value for the table array can be created by command-T ;)
Dude, you rock. Thank you so much for making this make sense and so easily. I will check out your other how too's when I have a chance.
Excellent tutorial! To the point and with various examples. Thanks!
Thank you so much!Much better than my TA! Without u I dont think I can pass the quiz~
you are awesome dude. you have no idea how this helped me in my data server and spread module.
Thanks for showing that F4 key can be used for absolute referencing...used to hate inserting the dollar signs manually.
you are the man... you are my GURU....
now i want to know about HLOOKUP let me search for your video...
god bless u
ditto same as other comments... been trying to figure this out for a while with other "help" functions. thanks so much.
thanks for the tutorial, i lost 1 hour with ms help, but got it right after 5 min with your clip!
thanks for making this sooooo much easier. great refresher
really educating and multiple examples really helps
God bless
Awesome - I struggle with VLookups & after watching this I wonder I ever did.
Thank you very much for this amazing clear and concise guide! It helped me so much!
You Rock dear, you helped in clearing my interview, God bless U!
Yay, I've never managed to get it right so quickly! thank you :)
Very useful...Excellent teaching skills.. Thank you
Thank you Ralph! excellent explanation on such a complex function, you make it sounds so easy :o)
Very nice video! You should make a website for all the TH-cam Excel videos, it would be very helpful to students and home-users a like!
Thanks Ralph. I can't believe I didn't know the F4 shortcut to absolute an entry....
thanks ,i was quite confused in it ,now my doubts are cleared
Thank you so much! Great tutorial and I love the absolute function. Had no idea! This saved me!!
excellent... evn th voice-quality is very clear..
Thanks! Great contribution to the internet
You sir are a legend, this was really, really helpful!
thnks dude..now i can go and get a distiction for my IT exam.. =D
very very good, I even learned more then what I was looking for !
Thanks man, you just helped me on my homework, that was a great explanation.
MANY THANKS ! GREAT INSTRUCTOR -THE BEST !
Clear explanation and it's really helpful. Thanks a lot!
Tip was as good as the presenatation. Thank you very much.
Dude this is a quality tutorial!!....
Much appreciated :-)
Extremely helpful video Sir. Thank you.
you are good at teaching. keep it up.
Thanks so much! You helped me SO Much in getting an assignment done!
Very helpful for my new job. Thanks for posting.
thanks, looking forward to your next excel tutorials
This is excellent stuff. Ur SIMPLY the very best!!
excellent video, good speech.. simple n easy.. tnks
Thank you for this great video! I'm just getting to know how to use vlookup in Excel, so this is a great introductory crash course. =)
Great video! It's amazing what you can learn now with a google search
Thanks very very much buddy .. and I agree .. the use of F4 was something really usefull
Marvelous, you solve my problem instantly, thank you
You're good teaching!! Thank you much!
You are brilliant! Thank you for sharing!
Thank you for the tutorial. Was working on a "lab" for a class and i'm new to excel but for my major have to take this excel intermediate course. I probably should have taken the beginner course first =/
Thankyou so much! You just explain it so clearly! Good vid!
that was awesome!! i am now one of your subscribers! ;-)
thanks dude!!!!
you helped me at work!!
(i work at Procter & Gamble - Gillette)
Keep up the good work!
incredibly helpful demo. thanks a lot!
You help me to deal my job. Thank you good guy.
very clear and easy to understand
VERY HELPFUL! Thank you for this video!
F4 is a toggle switch for absolute/relative status
Use the F4 key to toggle back and forth between Absolute and Relative reference.
thanks again for the whole tutorial .. that was really helpful :)
Great tutorial and well presented. Do you have any tutorial for using match and index function?
Thanks man.........you save my day.
Super!!! You are a Mahatma!!!!! How about a lesson on Offset. Why and how do we use it. Bless ya.
Absolutely brilliant! Thanks.
Thanks sooo much, so simple once you know how!
Good tutorial! However, the third example (bonus) should have used only one lookup table with three columns -- Year, Rank, Bonus/Pct. It will be more clear & easier.
SO helpful, thank you for saving me.
Excellent ...extremley useful!
Thank you.. Thankyou ... Such a great tutorial!
thanks for the help, i might stand a chance in my interview !
excellent presentation..thank you..it was very helpful :)