mine just says "Your a bit ahead, so I'll let you struggle some more" and walks away. he doesn't even explain anything in the first place. so aggravating.
Kevin, thank you for this vlookup and your pivot table y'videos-- yes, I have created an acronym/abbreviation/phrase of youtube and video--as well. These two videos explained things in a very simple manner. I went the extra mile and created the spreadsheet's of the examples you show to actually do the vlookups, hlookups, and pivot tables as you show to GET the concept down and not be afraid or in the unknown of what they do.
I have been trying to do a v-look up and with your tutorial it final worked....the one step I was missing was the data in the range I was looking in had to be the first column on the left. Thank you so much!
Hi Kevin, I've been watching your tutorials and they're great, thank you! I've been struggling with vlookup but you've made it so easy!! It would be helpful if you would have a spreadsheet to each video to practise with too!
It's not hard to create the spreadsheet based on the examples he shows. I'm simply replying here before someone else replies and starts trashing the guy since that happens a lot on the net.
Today my science teacher said that I need to do something called a "v lookup" in order to do something in our assignment, he also said it's really hard and it's not worth it to do, saying it took him an hour to learn. fine I said and I learned v lookup thanks to you, I'm going to now impress my teacher thanks to you.
Important tip for data organization: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊
🔢 Find the spreadsheet that I used here: 1drv.ms/x/s!AmxrofZZlZ-wg-UAG2yiAHEc_IA6UQ 🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Hello, and many thanks for the material you've been sharing - it's very useful! One question. Why for the approximate match the vlookup returns initially $50 for Jennifer? Thank you in advance and greetings from Athens, Greece!
Do you have a video that shows how to compare one spreadsheet with another? I never can figure that out when I am looking for matches on two separate workbooks/files. Thanks!
I'm taking a course on excel and the textbook seems written in a language other than English. I just wasn't getting it. Looks so ez now. On to xlookup and if(and) vids Thx for this
I just found you today 😢😢😢 Please can you mentor me, I am in Nigeria and I am a beginner learning data analysis, please reach out if you can, I will be so grateful. Your teaching pattern is amazing. Thank you so much and I anticipate hearing from you. 😊
You've taught me more than my "teacher" at school to be honest. They make it so confusing sometimes when it doesn't need to be.
mine just says "Your a bit ahead, so I'll let you struggle some more" and walks away. he doesn't even explain anything in the first place. so aggravating.
Saame G
I have literally been struggling with this for my course at WGU but you made it so simple in the matter of 6 minutes thank you!
Nice question Quiana Pascalau
Dddddddf
Literally here for the same reason. They suck at explaining it but Kevin is my hero lol
Yes, same challenge i had here but he simplified it so well. xxx
Kevin, thank you for this vlookup and your pivot table y'videos-- yes, I have created an acronym/abbreviation/phrase of youtube and video--as well. These two videos explained things in a very simple manner. I went the extra mile and created the spreadsheet's of the examples you show to actually do the vlookups, hlookups, and pivot tables as you show to GET the concept down and not be afraid or in the unknown of what they do.
The best tutorial on the internet.Thank you Kevin!
I am from India. nd I was looking for what I got here. Thank u so much Kevin for explaining it in a very easy way..
The only dislike is coming from Jennifer and Eric
lmao
Ahahhahahhahaha
Lmao...Good one!
😂😂👏
😂
I have been trying to do a v-look up and with your tutorial it final worked....the one step I was missing was the data in the range I was looking in had to be the first column on the left. Thank you so much!
Excel is amazing. So is your teaching skills. Your the reason I am going to smash my ICT exam.
YOU SAVED MY LIFE FOR MY NATIONAL EXAMS! THANK YOU SO MUCHH
Thank you so much! Hopefully I pass my Computer Science exam now ;)
Thank you so much for this tutorial! I looked at quite a few vlookup tutorials but yours made the most sense for me. cheers!
I`m pleased❤, I started this today but now fully understand what`s happening, Keep it up!!!!!!
Hi Kevin, I've been watching your tutorials and they're great, thank you! I've been struggling with vlookup but you've made it so easy!!
It would be helpful if you would have a spreadsheet to each video to practise with too!
It's not hard to create the spreadsheet based on the examples he shows. I'm simply replying here before someone else replies and starts trashing the guy since that happens a lot on the net.
I been looking for many videos to figure out how this equation works but I never finds how easy way to get results. Wonderful
I finally got how these functions work. It's perfectly clear now! Thank you very much for the video!
Sir, please make lots of video. Your explanation way is very good
Hi Kevin.. thanks very much this tutorial,I learnt it within 5 mins..
God bless you
Love the way you explain... you are my Microsoft Guru!
Simplest way to teach. Amazing.. Thanks a lot Kevin.
Thank you so much. I have lots of learned from your videos bro..!! God bless you. love from India...
that energy in the beginning is extraordinary🤣🤣🤣🤣
Thanks! I am learning a lot through these videos.
Thank you so much for this video. You explain things so well.
This would help out for my examination thanks a lot man
Good stuff. Thank you! I needed this quick refresher.
Thank you so much brother the explanation was very clear
you're the reason I'm passing my CAT NSC tomorrow
Kevin thank you. Very helpful video and well explained.
Thanks for the video! Really helpful. Eric and Jennifer are probably regretting their decision now :)
Thanks Kevin. I use vlookup all the time
You are the best Kevin!
Danke!
Thanks so much! Much appreciated 🙏
loved your tutoring. Keep it up..Jennifer and Eric sure need to donate..lol
Thank you Kevin for explaining the concept so clearly :)
Amazing and easy ☺️🎉
Great one, thanks for this🎉
This was simple and effective. Thank you!😊
Great, you have made it very EASY, Thanks Kevin.
Very good video on teaching v and h lookup. Goodwork!
Another solid video! Thanks my guy.
Thank you Kevin. You made it simple and made me understand well
Hi Kevin. You're my first choice for Excel training; thank you for the videos. Can you recommend a monitor to use while working with Excel?
Today my science teacher said that I need to do something called a "v lookup" in order to do something in our assignment, he also said it's really hard and it's not worth it to do, saying it took him an hour to learn. fine I said and I learned v lookup thanks to you, I'm going to now impress my teacher thanks to you.
That's awesome 👍
This never gets old
Important tip for data organization: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊
Easiest way really you are genius
Would like this twice if I could, thanks:)
🔢 Find the spreadsheet that I used here: 1drv.ms/x/s!AmxrofZZlZ-wg-UAG2yiAHEc_IA6UQ
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Fantastic Kevin from NZ!!!
Great tutorial!!! BTW is it just me or Kevin looks like Superman :P
Appreciate the clear, brief explanation!
Thank you so much Kevin!! You are great!!
Nice2. Learned it also for 6mins. Heheheh thank you
Hello, and many thanks for the material you've been sharing - it's very useful!
One question. Why for the approximate match the vlookup returns initially $50 for Jennifer?
Thank you in advance and greetings from Athens, Greece!
Do you have a video that shows how to compare one spreadsheet with another? I never can figure that out when I am looking for matches on two separate workbooks/files. Thanks!
Thank you so much for this Tutorial.
this was perfect at perfect time
Thanks man. Simple and easy.
Thankyou Sir🙏❤👼👼
Thank you so much....that was a very easy and effective way to teach 👏
Thanks again...very lazy to review these topics especially now that I speak English and all formulas change. Thanks 😁
Thank you so much for this! It was easy to follow.
U made it so simple i won't forget this
thank you you helped me brfore my exams
Your video was helpful... Now how can i get both Matts to appear individually on the list .
eg. If i have both two Matt's in each of the sheet
you are a pretty generous guy!
Thank you for the demo 🌹
OMG...so glad I found you!
Thank you so much this was very informative
Excellent video!!
Thank you sir this video is really helpful for my semester practical
Tx this was useful for my exams
Very simple to understand and it helped a lot. Thanks for this!
thanks for this video, it helps me a lot
Glad to hear that!
You are amazing!
Damn that was very well explained
hey you are so good at explaining this ,,perfect !!!
Thank you so much sir 🙏🙏
Your'e brilliant. Thank you
YOU ARE A GENIUS!
Best vlookup video
Nice and thank you for simple video
Excellent video, very helpful! Thanks.
Thanks for this I would watch over and over until it sinks into my subconscious. I have been struggling with vlookup
Amazing!!! Thank you 😊
I'm taking a course on excel and the textbook seems written in a language other than English. I just wasn't getting it. Looks so ez now.
On to xlookup and if(and) vids
Thx for this
thxx budyyy very helpful videoo😀
Thanks bro, you're great
Great video. Thank you so much!
Hi Kevin, great done. Well explained and easy to be followed. Saludos
Excellent vid. only thing is that the excel table is a bit blurry but totally excellent content for this vid.
Very easy to folow thank you
Thanks, I learned that jenifer and eric aren't generous like you 🙂
THANKYOU KEVIN
Thank youuu 🙌🏾🙌🏾🙌🏾
Thank you omg, cleared EVERYTHING up.
Correctly explained ...
Thank you so much for the easy explanation!
I just found you today 😢😢😢 Please can you mentor me, I am in Nigeria and I am a beginner learning data analysis, please reach out if you can, I will be so grateful. Your teaching pattern is amazing. Thank you so much and I anticipate hearing from you. 😊
Nigerians you guys always show how dull you're. Make tutor reach out to you
Worked, thanks!