Vlookup Excel Best

[@rocketinthesky]

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

[@maggieblyth2077]

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

[@donnaturner3377]

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

[@julieshaw8316]

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

[@organizedbytoya1]

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

[@rdjalayer]

+LaToya Jones thanks for forwarding

[@marshah9249]

"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.

[@jonchapman621]

You can watch kzbin.info/www/bejne/l3eZhoywos55bKc as well

[@jodisue1984]

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

[@chetbrunt]

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

[@traceskimill9584]

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

[@berenz]

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

[@northerngirlbergeron4848]

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

[@cenkconk]

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..

[@odanew3795]

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

[@DirkIronside]

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'

[@thefoxymslady]

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!

[@moshemaor1731]

In my opinion, Jalayer Academy is the best Excel teacher in KZbin site. Thanks.

[@jsvef79]

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

[@rsktcs]

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

[@CathSaff]

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

[@kylami2501]

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

[@rahulsharma-gn8yo]

Hi buddy thanks a lot mate I have gone through about 5 to 10 videos on KZbin 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

[@tdrayford]

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.

[@sarahb6850]

I actually really appreciate the intro to this

[@Newskinned]

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

[@anupambhomia]

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

[@cathylau3493]

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

[@payette_1017]

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.

[@britishmiller3665]

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!

[@natarajanrenganathan7631]

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

[@tombedys]

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

[@m3m3h1h1]

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

[@toniaclark994]

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

[@nonayoubiz2186]

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!!!

[@britishmiller3665]

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!

[@carrjar]

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

[@ashleymaree683]

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

[@ernestoanyan-denkyijr.4140]

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.

[@Logan4TheWin]

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

[@skullduggerygillen]

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

[@ganeshprem3043]

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

[@maelewis258]

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!

[@atulp3360]

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

[@aakashmehta3620]

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

[@krispy2flux]

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

[@rdjalayer]

Thanks, you are the 3rd person who has said that. I have to look into this. haha

[@cavsfanz11]

+krispy2flux Now that you said that I can't focus on the actual video lol just his voice!

[@carl_anderson9315]

For Christ sake... They were on a break!

[@robdcollector2808]

Woods ...i fkn hated ross

[@dolfenarora9467]

very true!!

[@TMVID]

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

[@LindaDooWop]

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

[@LaToyaa100]

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

[@Audiovisual00]

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

[@SumOfSquaresMusic]

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

[@carriehill911]

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

[@elisavetvaina3695]

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! :-)

[@skm7159]

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.

[@yadav5014]

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

[@TheChanelbelle]

Thank you so much, best video so far on vlookup

[@nemathassnain8522]

Great presentation. Your voice is very soothing.

[@witty_net]

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

[@deniseogir2434]

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.

[@paigesilva23]

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

[@AnmolRao]

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

[@marcoatzeni10]

Thank you for explaining it in a easy way!!

[@yichengliu]

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

[@KingsintheWild]

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

[@lightplay-photography]

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

[@susanoosthuizen9338]

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

[@solonreid4824]

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.

[@blakecrsftvlgs224]

Excellent example! This just helped me out tremendously! Thanks

[@elegantserenade]

Thank you. Very helpful and easy to understand. This will help me a lot!

[@DodgeBrothers36]

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

[@mahsudscouts8776]

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

[@tulan5895]

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

[@Jtflash]

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

[@mtismee]

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

[@PrinceInShadow]

thanks man, really helps alot. Just 1 question, what if the lookup/reference table was in another sheet?

[@annamuller3976]

Thanks Jalayer, your lesson really valuable.

[@sojitomuchswag]

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

[@joythompson2074]

Question - Can the lookup table be on a different worksheet? Thanks for making this simple!

[@ksarubbe]

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

[@jean-mariopayen2741]

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

[@Ta-Rich]

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

[@rdjalayer]

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

[@Loveydovey708]

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

[@everettsmith448]

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

[@jeremygard]

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

[@PawsAndKeys]

7 years ago, hope this guy bought TSLA

[@hanaesatomura4316]

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

[@sandraparker928]

Thank for the video, although the I still haven't figured out how to auto fill customer information on multiple lines, I have learned a lot. Any video I am missing on that topic?

[@6578910a]

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

[@jtserpico]

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

[@genecontreras1020]

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

[@zaq1xsw271]

The Best Best Best simplified explanation ever.

[@shrikesshrike988]

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!

[@Emanuel3437]

Best Tutorial ever, Super easy :) Thanks

[@Rani88407]

Thanks a lot. God bless you for an excellent video. U cleared my doubt completely. Thanks again Bro!!

[@Earn-w-AAS12]

+Komal Talreja hello baby hower u.

[@Earn-w-AAS12]

looking so nice i love u.

[@RehanKhan-rt3wr]

Babee you are hot. Will you marry me? Please say yes.

[@Earn-w-AAS12]

yes why not. i will marry with u. if u r true girl.

[@RehanKhan-rt3wr]

+Komal Talreja I like your photo. Please marry me babe.

[@3IN1COFFEE]

Thank you for this! It was explained clearly.

[@shubhamirs]

Thank you so much ....You explained very well.

[@JediPhantom]

Fantastic use of VLOOKUP..thanks

[@rdjalayer]

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.

[@nycfunny]

the best video on vlookup I have found thanks

[@folasadebangali1449]

absolutely perfect video! thank you so much

[@mageede7829]

Good job bro, I was asked in interview about this V look up. so thank so much! keep up the good work

[@iJohnnyJB]

What do you press to get the table in absolutes? I'm new to vlookups. Thanks for the videos!

[@ardalanjalayer8890]

you click the F4 key right after you highlight the table array

[@rdjalayer]

you click the F4 key right after you highlight the table array

[@iJohnnyJB]

Jalayer Academy Thanks for the response. I guess I should have pointed out that I am using Office '11 for Mac. My F4 key is used as a launcher for Launchpad, a feature of the Mac OS, so F4 doesn't work for me in excel. Do you know of another way of doing this? Thanks again

[@iJohnnyJB]

Jalayer Academy Figured it out. It's Command + T for mac

[@rdjalayer]

Johnny B nice

[@jorgeborge79]

great tutorial! can you make some example also for copying the value of one cell to one colum for every hour automatically? thanks