Vlookup simply explained

  Рет қаралды 2,855,078

Excel to Excel

Excel to Excel

Күн бұрын

Пікірлер: 1 600
@tsnstt
@tsnstt 2 жыл бұрын
I’ve been trying to understand this for months and months and a few of my colleagues have tried explaining this to me but I think they are more interested of showing me how much they know and how much smarter they are than me. They explained it to me over and over again but I always feel they are keeping the most important details out so I can keep going back to them for more help every time I’m analyzing a new spreadsheet. By going back every time it makes me feel incompetent and it makes them feel superior. Not anymore!!!! Now finally!!!!!!! I come across this video!!!!! No BS just pure explanation and pure understanding on how things are being done; and why things are being done the way they are. So I finally went back to my colleagues and explained to them and showed them exactly the same thing you showed me in your tutorial. I also went to the rest of the colleagues and showed them these same instructions. Now everyone understands this in my office and those initial colleagues that were more interested in looking smart and being superior are now looking dumb and stupid. We all now know it and no one is going to them for help anymore. We are all finally on the same page. Thank you.
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
First of all, thanks a lot for watching the video and sharing your valuable comment here. I am so happy to hear that the video helped you in your daily work and that you have been very kind to share it with your colleagues as well. I believe the most interesting part for me is that you have shared your knowledge with people around. This really means a lot to me reason being it coincides with my purpose here on KZbin i.e. to share my knowledge and learning with people around. I really hope that other colleagues of yours could also benefit from our mutual efforts. I wish you all the very best for your journey of learning and sharing and again thank you for sharing your feedback with me. I wish you a wonderful day ahead. Cheers.
@cheechee5378
@cheechee5378 2 жыл бұрын
Hello Tyson, When i read your comment, i bust out crying.. it happened to me too. They made me feel horrible to the point i lost my job.. How can people not work as a team so we can all be productive.. I am soo very sorry you and anyone else goes through the fact that no one want to train or teach.. It is a horrible feeling. I agree this was the BEST video i seen on VLOOK UP. I am learning excel and trying to move on with my life.. Please take care :)
@MrAsched
@MrAsched 2 жыл бұрын
exactly , He Elaborated it perfectly.
@tsnstt
@tsnstt 2 жыл бұрын
@@MrAsched yes he did 😊
@aniawo5119
@aniawo5119 Жыл бұрын
​@@cheechee5378 don't worry, everyone had to learn this for the first time. I have learnt this today, my mych younger colleague explained this to me, and I felt terrible because I am senior to him. He knows so much more than me, I sometimes question my existence 🥲
@kristinurban10
@kristinurban10 4 жыл бұрын
I've been trying this function for MONTHS and everyone has made this so complicated. This was so easy to understand and I got it in a few minutes! Thank you so much for the tutorial.
@shabanakhan7450
@shabanakhan7450 3 жыл бұрын
Very true. This was the best explained video so far on this topic. It was simple and easy to comprehend. Thank you so much for sharing and putting it out there.
@michaelkrajkovich6251
@michaelkrajkovich6251 11 ай бұрын
This was my 5th tutorial I looked at and resonated with me. Thank you for keeping it simple and NOT over complicating it! It saved me a lot of time and heart burn :-) 😁
@ExceltoExcelE
@ExceltoExcelE 11 ай бұрын
Lovely, só glad that you could benefit from the video. Thanks alot for the note
@johnallen6787
@johnallen6787 5 жыл бұрын
Sir, I swear I did NOT understand VLOOK UP until I seen your video. I watched it once and got the intent of the function with no confusion. Thanks for posting this!
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thank you for watching the video. I am glad that it was useful and you liked it. Please stay in touch for more such videos
@L3X369
@L3X369 4 жыл бұрын
a few months ago we had a 3 hours training for this function at work, but i didn't managed to learn anything, but thanks to you, now I know.
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Wow, I am glad it was helpful, Thanks for your comments. Stay in touch for more such stuff.
@stupify454
@stupify454 Жыл бұрын
me without any excel subjects when i was studying have been watching several tutorials of VLOOKUP but have not understand , but you have explained this crystal clear and now i know how to do it... thank you sir
@mayso820
@mayso820 3 жыл бұрын
Like everyone else mentioned, the easiest Vlookup explanation ever! And I've tried time and time to understand it, finally grasped it, followed the instructions along the way of the video and worked. Thanks again.
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
I am glad that it helped. Thank you so much for watching the video and sharing your valuable comments here. Please stay in touch for more such videos on my channel. Have a great day ahead.
@Haroratech
@Haroratech 3 жыл бұрын
Trust me the only tutorial which explained the Vlookup and results which we want to see Explains perfectly I watched 100 Videos and Finally found the Best Cheers
@crazywarriorsofsfdc8193
@crazywarriorsofsfdc8193 4 жыл бұрын
I explored almost 10 videos on Vlookup but got the final and unforgettable clarity from your video. Really appreciated Dear Sir!!!
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks alot for watching the video and your comments. Stay tuned for more such videos.
@MH-fe9hr
@MH-fe9hr Жыл бұрын
First time any google search, written narrative, or video of vlookup that actually made sense. THANK YOU!
@ExceltoExcelE
@ExceltoExcelE Жыл бұрын
Your comment made my day thanks so much for watching the video and sharing your valuable comments here.
@B58_Bless
@B58_Bless 5 жыл бұрын
I've seen other vlookup videos and tell me why yours was way better understanding. You clearly even asked questions when you were teaching. Perfect, clear, easy and step by step literally. Thanks
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thanks alot for the note and watching the video. I am glad that it was useful. Please stay in touch for more such videos.
@B58_Bless
@B58_Bless 5 жыл бұрын
@@ExceltoExcelE sure will! Thanks for your reply this really help me out. Honestly, I was watching other videos but when I came across yours (being the 3rd one) you honestly made me understand it. Blessings.
@prakashmb2897
@prakashmb2897 4 жыл бұрын
kudos to you.the way you explained was so easy to understand.thanks to you.
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks alot for watching the video and sharing your valuable comments. Please stay in touch with my channel for more such content.
@alfiyasahil8221
@alfiyasahil8221 5 жыл бұрын
He teaches so nicely. I had a gap of few years,but his guidance made it very quick for me to recall all. Thank u sir. may Allah bless you always.
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thanks alot for watching the video and sharing your comments. Please stay in touch for more such videos.
@philiplbrown
@philiplbrown 2 жыл бұрын
What a superb tutorial. Very well structured and easy for beginners to VLOOKUP to follow.
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Glad you liked it, thank you very much for watching the video and sharing your feedback.
@mjsabir
@mjsabir 3 жыл бұрын
Honestly, I was struggling to understand the VLOOKUP function until I saw this video where you made the function very easy to understand. Thank you.
@rushdairfan4407
@rushdairfan4407 5 жыл бұрын
WOWWWWWWWWWWW!!! VLOOOKUP was never this easy to understand. This video is so easy. never never it was simplified the way u did. Kudos!!
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Perfect thanks for sharing your comments. I am glad that you enjoyed the video and it was useful. stay tuned for more such videos.
@cmart674
@cmart674 4 жыл бұрын
Finally - someone who knows how to explain it correctly -- thank you!!!
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Glad it was helpful! Please stay in tune for more such tutorials.
@stephondavid5210
@stephondavid5210 5 ай бұрын
I have an interview coming up for an analyst position, this has helped me tremendously and I feel more confident ! Thank you !
@ExceltoExcelE
@ExceltoExcelE 5 ай бұрын
Fabulous, I am glad it could help you. I wish you all the best for your interview and future job as analyst. Good luck!
@renebass4912
@renebass4912 3 жыл бұрын
This was the easiest explanation and walk through I have seen! I thank you for saving me from deep embarrassment at the job 😬
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
Glad I could help! Thanks alot for watching the video and sharing comments.
@ruchisharma667
@ruchisharma667 2 жыл бұрын
Thank you. This logic helped me understand that Vlookup cannot be used when the data has a return value column before the lookup value column. The column order needs to be reorganised before using Vlookup!
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
I am glad Ruchi that it helped. Thank you so much for watching the video and sharing your valuable comments here. Please stay in touch for more such videos on my channel. Have a nice day!
@dravikrish7323
@dravikrish7323 6 жыл бұрын
This is one of the best vlookup tutorial so far I have seen. Thank you very much.
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
Many thanks for the feedback, Stay in tune...
@mblingam
@mblingam 4 жыл бұрын
In one word Simply explained. Really very Good Teaching method and simple language used to understand by everybody. Many many thanks.
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks a lot for watching the video and sharing your valuable feedback. You made my day. Please don't forget to subscribe the channel for instant access to more such videos.
@tiffanyjimenez5245
@tiffanyjimenez5245 4 жыл бұрын
Seriously now I understand how to do Vlookup. The way you explained it! Thank you!
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks alot for your feedback. Keep in touch for more such videos.
@yolandewan2798
@yolandewan2798 6 жыл бұрын
Thank you!! You saved my life.i am very bad with excel but you have solved my problem.at least now i know how vlookup works. Thank you again!
@yolandewan2798
@yolandewan2798 6 жыл бұрын
I do have a question.sometimes i see instead of false or true, people put 1 or 0 in place of it.are they the same?
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
@@yolandewan2798 yes , those are same
@princessokwuba1472
@princessokwuba1472 5 жыл бұрын
Was having difficulty in class understanding but now I think with what have watched I have bn able to understand clearly how to use Vlook up thank you ☺
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
thanks for watching the video and sharing your comments.
@kbgkumar
@kbgkumar 4 жыл бұрын
thanks sir, i am trying to learn vlookup for long time, but your teaching is super and crystal clear, i tried and its working. thanks
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks alot for sharing your comments mate. I wish you good luck with it. Please do subscribe and stay in touch for more such videos.
@IbrahimJatau
@IbrahimJatau 4 жыл бұрын
This is the best video and explanation on Vlookup! Thank u so much
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
Glad you think so! thanks for watching the video, stay in touch and don't forget to subscribe for more such videos.
@nayyersyed2715
@nayyersyed2715 6 жыл бұрын
JAZAKALLAHA AND THANK YOU BRO YOU EXPLAINED IN SHORTLY AND IN DETAIL KNOW I GOT EXACTLY HOW TO USE V LOOK UP
@sumypadookaran85
@sumypadookaran85 4 жыл бұрын
No one explained it as precisely & clearly as you did.. Thankyou!
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thank you very much for watching the video, stay in touch for more such stuff
@HeAloneIsGod9901
@HeAloneIsGod9901 12 күн бұрын
At last you explained in simple terms, thought l was never going to understand vlookup after going up and down Thank you sir!
@ExceltoExcelE
@ExceltoExcelE 2 күн бұрын
Thank you for watching the video and sharing your valuable comments here. Please stay in touch for more such videos on my channel. I am glad that you could benefit from the video.
@ilyo2010
@ilyo2010 5 жыл бұрын
Simply, very well explained. I've viewed so many videos on Vlookup and this one is by far the best!
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Many thanks for sharing comments. Stay in touch for more.
@masambanasser8141
@masambanasser8141 3 жыл бұрын
True
@breadmancatvideos
@breadmancatvideos 7 жыл бұрын
Very clearly explained. After watching this video, the whole think just clicked. I now understand the syntax usage. Thank you.
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks alot for your feedback, stay in touch for more such videos on my channel
@dhirajpandey6018
@dhirajpandey6018 6 жыл бұрын
Sir you explained it amazingly. i never found vlookup so easy before this. Many thanks
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
Thanks alot Dhiraj for such lovely feedback, I am glad you liked and enjoyed the video
@VictorVictor-qj3jl
@VictorVictor-qj3jl 4 жыл бұрын
kzbin.info/www/bejne/l2rOfKt7j6x2fc0 I advice to subscribe to this guy
@BalaMurugan-gn8gu
@BalaMurugan-gn8gu 4 жыл бұрын
@@VictorVictor-qj3jl (♥ω♥*)♡⃛◟( ˊ̱˂˃ˋ̱ )◞⸜₍ ˍ́˱˲ˍ̀ ₎⸝◟( ˊ̱˂˃ˋ̱ )◞♡⃛♡⃛◟( ˊ̱˂˃ˋ̱ )◞⸜₍ ˍ́˱˲ˍ̀ ₎⸝◟( ˊ̱˂˃ˋ̱ )◞♡⃛♡⃛◟( ˊ̱˂˃ˋ̱ )◞⸜₍ ˍ́˱˲ˍ̀ ₎⸝◟( ˊ̱˂˃ˋ̱ )◞♡⃛
@prazzi2149
@prazzi2149 2 жыл бұрын
He really did. I'm subscribing.
@rahulpunjabi2809
@rahulpunjabi2809 2 жыл бұрын
i have nearly seen close to 10 videos but this was the only one that made sense and the only video through which i have learned how to use this vlookup
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Rahul, first of all thank you very much for watching the video and sharing your feedback with me. I am so happy that video could be useful for you and you could learn, wish you a wonderful day ahead and happy learning!
@janeale5100
@janeale5100 5 жыл бұрын
Thank you I think I now finally get it and see where I was going wrong with my vlookup formula’s. Now I should be able to design some beautiful spreadsheets :)
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thanks alot for watching the video and sharing comments. I am glad that it helped. Stay in tune for more such tutorials.
@helenzhan7564
@helenzhan7564 Жыл бұрын
This is an excellent tutoring. I was able to finish my vlookup project just simply following your video. Thanks very much!!!
@ExceltoExcelE
@ExceltoExcelE Жыл бұрын
Thank you for the lovely note and watching the video and sharing your valuable comments here
@lisadelgado5733
@lisadelgado5733 5 жыл бұрын
I am having a really hard time learning formulas for excel in my business class and this video finally got vlookup to click! Thank you!
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Many thanks for your comments Lisa and Glad that you enjoy the videos, stay tuned for more vidoes :)
@pennyhayes1God
@pennyhayes1God 8 ай бұрын
You are truly good at teaching. Like other viewers I finally get it now. I went through something similar with colleagues wanting to show how smart they were instead of actually teaching/training you. I will be coming to your channel for all things excel. Thank you very much and God bless you! 🙏🏽❤️
@ExceltoExcelE
@ExceltoExcelE 8 ай бұрын
Wow you really made my day. Thanks alot for watching the video and sharing your thoughts. I am glad you found it useful. Please stay in touch for more such videos and tutorials on my channel. Thanks again for the best wishes. Stay blessed.
@AliKhan-om6yd
@AliKhan-om6yd 4 жыл бұрын
IMPRESSIVE, VERY STRAIGHTFORWARD EXPLANATION ..😘.. 10 OUT OF 10 BRAVO
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks alot for watching the video and sharing your comments. Please stay in touch for more such videos on my channel. I have recently uploaded a video regarding Xlookup as well. I hope you will find that interesting and useful as well. Once again thanks alot for your wonderful opinion and rating.
@Travel_Geek_Channel
@Travel_Geek_Channel 2 жыл бұрын
Very clear explanation. Thank you master of the green cross!
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
thanks for watching the video and sharing your feedback
@claguilera2058
@claguilera2058 5 жыл бұрын
Thank you for explaining vlookup properly and not just clicking as with other videos.
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thanks alot for watching the video and feedback. stay in touch for more such videos.
@ducdo3298
@ducdo3298 2 жыл бұрын
I understand more how to use Vlookup through this video. Thank you so much for your times. God Bless you.
@cheryl450
@cheryl450 6 жыл бұрын
Excellent, thank you very much.it was very helpful.
@xcaliberVirus
@xcaliberVirus 4 ай бұрын
August 2024. Amazing video. I got a job needing vlookup and your video is byfar the most helpful
@ExceltoExcelE
@ExceltoExcelE 3 ай бұрын
I am so happy that it was useful for you. Thanks for letting me know and thanks for sharing your thoughts with other viewers too. I hope you enjoy upcoming content on my channel, please stay in touch for more such videos on my channel.
@srikaanth062
@srikaanth062 4 жыл бұрын
Superb! He made it simple.
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Glad you liked it!
@chocomandu1
@chocomandu1 4 жыл бұрын
You are the only person who explained this super clear. Thank you!
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Glad it was helpful!
@pavankumarneelamsetty7656
@pavankumarneelamsetty7656 5 жыл бұрын
Thank you sir... ur easy way of explanation made me ace my work. Got appreciation from boss. All that credit goes to you. Thanks alot Sir
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thanks alot for watching the video and sharing your comments. Please stay in touch for more such videos.
@1LuckyGirl1975
@1LuckyGirl1975 11 ай бұрын
Friend you're brilliant and left the complicated jargon at the door. You stayed on the topic instead of jumping around to the what if scenario that many posters do which confuses the point of the video. Many thanks and blessings 🙏
@ExceltoExcelE
@ExceltoExcelE 11 ай бұрын
Thanks so much for watching the video and sharing your thoughts. I am glad you could enjoy and benefit from it.
@deenad3562
@deenad3562 6 жыл бұрын
Explanation: False means only an exact match to the lookup value will be searched, True means the closest match (of equal or lesser value) to the lookup value will be searched. In the case of ID numbers and such, an exact match is critical so False is the correct choice. In the case of a continuous lookup value such as Weight, you may prefer True.
@xlsdeal
@xlsdeal 5 жыл бұрын
Deena Daggett kzbin.info/www/bejne/r4GWc4SbfrF-mqs Did You forget your excel sheet password. This link helps you.
@AnilKumarperunthattil
@AnilKumarperunthattil 5 жыл бұрын
kzbin.info/www/bejne/bXukgaNsht2XY7c
@YouTuberr285
@YouTuberr285 Жыл бұрын
Thank you so much. No one explains the True / False
@Proud_07
@Proud_07 10 ай бұрын
you are one of the best instructors I have ever met in my life, in addition to your expertise in knowing the concept, your way of explanation and delivering the concept is way above and beyond
@ExceltoExcelE
@ExceltoExcelE 10 ай бұрын
You have absolutely no idea how much this compliment means to me. Thank you so much for your kind words and for taking time to watch the video. I am glad that you enjoyed it and you like my style of conveying message. Have a great day.
@annettefreeman8671
@annettefreeman8671 3 жыл бұрын
THANK YOU! You are going to make me shine at work!
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
You can do it! thanks for watching the video and sharing your experience, please don't forget to subscribe my channel for more such stuff. Good luck !!!
@craigkrobinson
@craigkrobinson 2 жыл бұрын
Actually worked, tried three others and THIS one worked FIRST TIME.
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Fantastic, so happy that you could benefit from the video. Thanks alot for sharing your thoughts and valuable feedback.
@itsmarialifestyle4355
@itsmarialifestyle4355 5 жыл бұрын
Thank you for sharing, I'm refreshing my excel knowledge for a job.
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thanks alot for watching the video and sharing your comments and experience. Keep watching.
@tonyralphs2502
@tonyralphs2502 4 жыл бұрын
This is awesome. Basic but critical. Thanks
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks alot for watching and sharing your comments, please stay tuned for more such videos.
@ercmansur
@ercmansur 6 жыл бұрын
Really Fantastic explanation and everyone easy to understand, the ways U explained..Gr8...
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
@SuperLalagogo
@SuperLalagogo Жыл бұрын
Thank you so much for very clear explanation. This is the first time that I understand what is Vlookup use for and how to use it.
@ExceltoExcelE
@ExceltoExcelE 11 ай бұрын
Thanks alot for the note and watching the video. Please stay in touch for more such videos on my channel
@tankluvskibble
@tankluvskibble 3 жыл бұрын
Best explanation and walkthrough of this function I've seen so far. Watched about 4:30 of your video while doing this with my own dataset and voila it worked. Thank you! Subscribing!
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
Thanks alot for sharing your thoughts on the video and subscribing the channel.
@麥西翻
@麥西翻 2 жыл бұрын
This is so easy to understand the concept of VLookup! Thanks ever so much for this concise explanation!
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Glad it was helpful! Thanks alot for sharing your comments and watching the video. stay tuned for more such videos on my channel.
@sabrinam4335
@sabrinam4335 6 жыл бұрын
Thank you for the clarification!! Much appreciated, understood everything that u have explained in ur video 💗
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
I am glad that video was useful and you enjoyed it, thank you very much for your feedback. stay in tune for more such videos.
@xlsdeal
@xlsdeal 5 жыл бұрын
Sabrina Mc kzbin.info/www/bejne/r4GWc4SbfrF-mqs Did You forget your excel sheet password. This link helps you.
@freelearn1655
@freelearn1655 4 жыл бұрын
kzbin.info/www/bejne/Z6XWY4WYr6qjkMU
@VictorVictor-qj3jl
@VictorVictor-qj3jl 4 жыл бұрын
kzbin.info/www/bejne/l2rOfKt7j6x2fc0 I advice to subscribe to this guy
@freelearn1655
@freelearn1655 4 жыл бұрын
Nice
@noems1871
@noems1871 3 жыл бұрын
I must agree to all other comments! Very simply explained. Thank you!
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
Glad you enjoyed it! and thanks alot for sharing comments, dont forget to subscribe the channel for more such videos
@Ff13jap
@Ff13jap 4 жыл бұрын
Many probably already said it, but grrrrreat explanation! Really easy to follow! You have another subscriber 😄👍👍
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Awesome, thank you for subscribing! Thank you very much for watching the video and sharing your comments.
@SapphireUnique
@SapphireUnique 3 жыл бұрын
best video mate thanks
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
Glad you enjoyed it, thanks for sharing your feedback, please do consider subscribing if you are interested in more such videos.
@anilmudakannavar79
@anilmudakannavar79 6 жыл бұрын
Thanks a lot sir, for sharing valuable knowledge regarding VLookup usage. Looking forward for many more in future
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
Thanks alot Anil for your valueable feedback, I am glad that you liked it. Stay in tune.
@AnilKumarperunthattil
@AnilKumarperunthattil 5 жыл бұрын
kzbin.info/www/bejne/bXukgaNsht2XY7c
@hollyberry1221
@hollyberry1221 3 жыл бұрын
Thank you, very easy to follow along with. I appreciate this so much.
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
I'm so glad that that video was useful for you. Thanks for watching the video and visiting my channel.
@biswajit6708
@biswajit6708 6 жыл бұрын
Very nicely explained, thanks
@NJM1016
@NJM1016 5 жыл бұрын
This vid helped me for my job interview. Thanks :)
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Wow.... Thanks for sharing your feedback and good luck. Stay in touch for more such stuff on the channel
@nowvoyager81
@nowvoyager81 2 жыл бұрын
This is the best explanation of VLOOKUP I've come across on KZbin. Very simple and easy to understand. Thank you!
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Wow, thank you so much for a fantastic comment. I am so happy that this video could be helpful for you.
@bettyegriffin1099
@bettyegriffin1099 6 жыл бұрын
This explains in perfectly. Thanks.
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
Many thanks for watching the video and your comments Bettye, stay tuned.
@gaetanamouzou1717
@gaetanamouzou1717 3 жыл бұрын
This is a best approach to explain this function that I never understood for years! Thank you!!!
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
Glad it was helpful! thanks so very much for sharing your feedback. All the best !!!
@samfisher2306
@samfisher2306 6 жыл бұрын
Very excellent lecture. I'm going to use this extensively at work
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
thanks alot Sam for such nice feedback. stay in touch.
@lhsfitness8983
@lhsfitness8983 6 жыл бұрын
Suleman Qureshi Sir. Sir can you make a video on Data entry in excel and can we club two data set which are similar.
@johnmitchellvitols5421
@johnmitchellvitols5421 5 жыл бұрын
@@lhsfitness8983 do I need a particular app I only have a Android phone and screen setup for my LOVER CLARA and myself
@johnmitchellvitols5421
@johnmitchellvitols5421 5 жыл бұрын
@@lhsfitness8983 okay can I get that on my Android phone screen setup
@m.adnankhan8245
@m.adnankhan8245 2 жыл бұрын
I love you, I was doing it wrong for many days, no idea which number to put in a column parameter, just able to do it in 7 mins of your video. Great work Sir.
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Dear Adnan, I am so happy that you could benefit from this video and it was useful. Thanks alot for sharing your thoughts. Please stay in touch for more such videos on my channel.
@Jai202
@Jai202 4 жыл бұрын
Love from India sir ji❤️❤️❤️❤️
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thank you very much Manoj ji... you made my day
@jocelynporlales1047
@jocelynporlales1047 2 жыл бұрын
Thank for this video sir, now I know how to use vlookup, I'm so happy.... Thank you so much, more videos on how to use excel In a simple way.. Very clear explanation and easy to follow the steps.. Godbless..
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Wow, thanks a million for such a wonderful compliment, I really appreciate it and means alot to me. That's for watching the video and sharing your valuable comments here. Please stay in touch for more such videos on my channel. Stay blessed and Have a nice day!
@vivianedoo8094
@vivianedoo8094 2 жыл бұрын
I never found a video so easy to understand and that actually worked. Thanks a lot for that. Would you have any videos about pivot tables?
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Thanks alot for the note and watching the video Viviane, yes absolutely there are a couple of videos on my channel around pivot tables. If you still have any specific questions around the topic please let me know and I will record a saperate video for you. Thanks
@iamsilentobserver
@iamsilentobserver 2 жыл бұрын
My current job requires me to use vlookups and I've been struggling to grasp it. Finally I understand. Thank you for this tutorial
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
I am so happy that you could benefit from the video. All the best for the next steps in the future and wish you a very bright career.
@mariamanocchio8894
@mariamanocchio8894 5 жыл бұрын
Thank you this was great. a Question: Is there away to pull in a range of data (columns 3, 4, 5, and 6) other than copying the formula and changing the reference value?
@RaghavPai
@RaghavPai 4 жыл бұрын
You might need to freeze the cell references.
@TekhXpert
@TekhXpert 4 жыл бұрын
No, you can't pull in range.
@SVnerd
@SVnerd 5 жыл бұрын
Excellent explanation. Informative and concise that a beginner or a refresher can comprehend.
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Many thanks for watching the video and your feedback.
@mivedi
@mivedi 6 жыл бұрын
Thanks, the tutorial is very specific and clear.
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
I am glad you enjoyed the video, thanks for your feedback. Stay in tune...
@optoid
@optoid 4 жыл бұрын
Thank you!! Building a sales order for my wife's company. This was very helpful.
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Glad it was helpful! stay tuned for more such videos.
@marcuspow
@marcuspow 5 жыл бұрын
Sir, I have a question when you track the VLOOKUP table. Why did it started with C. Why can't it starts by B,
@pyroglyphies
@pyroglyphies 3 жыл бұрын
that is because C stands for COLUMN.
@marutirathod2055
@marutirathod2055 5 жыл бұрын
Thank you for ur explain its easy to understand to all people.
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thanks for the feedback
@gerryclarke1506
@gerryclarke1506 2 жыл бұрын
This was so clear and helpful - thank you :) Like others who've commented, I've had colleagues try to explain this in the past and I've got hopelessly confused. I hope you will product lots more videos and I will certainly be watching them.😃
@ExceltoExcelE
@ExceltoExcelE 2 жыл бұрын
Lovely, thanks alot for your note and watching the video. Yes please do stay in touch for more such videos on my channel. I am glad that it helped you. It means alot to me. Thanks again
@Sindhuiyer10
@Sindhuiyer10 4 жыл бұрын
Sir you have explained the Vlookup in such a way that any students can understand. Excellent
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks a ton for comments mate, I am glad it was useful for you. Stay in touch for more such videos and content.
@MrNiceWatch21
@MrNiceWatch21 5 жыл бұрын
dude, you made this so simple. Thank you!
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thank you for watching the video. I am glad that it was useful and you liked it. Stay in tune for more such videos
@richchick540
@richchick540 10 ай бұрын
This was sooooooooooooooooooo freaking HELPFUL!!! OMG! I was racking brains trying to figure out what number should go in that spot! AWESOME!
@ExceltoExcelE
@ExceltoExcelE 10 ай бұрын
Wowwww, I am glad that you could benefit from the video. Thanks alot for the note and watching the video.
@4Jibran
@4Jibran 5 жыл бұрын
Sir Thank you , please advise how can I get access toall your videos .
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thank you for watching the video. I am glad that it was useful and you liked it. Simply subscribe to my channel and stay in touch for more such videos on my channel.
@ms.orcha_
@ms.orcha_ Жыл бұрын
By far the clearest explanation! Thank you so much, Sir. Now I know how to use it.
@ExceltoExcelE
@ExceltoExcelE 11 ай бұрын
Awesome, glad you found it useful.
@mudhasirshaik7557
@mudhasirshaik7557 8 жыл бұрын
Assalamualaikum best way of explaination .....keep going
@ExceltoExcelE
@ExceltoExcelE 8 жыл бұрын
JazaakAllah Mate, thank you
@bashiromar127
@bashiromar127 Жыл бұрын
I have seen many tutorials regarding this function they really made it tough but this one is so easy got the concept in minutes Thanks ❤
@princeavinashg
@princeavinashg 6 жыл бұрын
Awesome buddy, take a bow... you have Excellently briefed about VLOOKUP... Thank you very much, Looking Forward to Excel and many other Functional Videos from you.
@xlsdeal
@xlsdeal 5 жыл бұрын
Avinash Gudapati kzbin.info/www/bejne/r4GWc4SbfrF-mqs Did You forget your excel sheet password. This link helps you.
@bidhyadahal3899
@bidhyadahal3899 Жыл бұрын
Explained in no time. Thank you so much for the insight. Great video.
@ExceltoExcelE
@ExceltoExcelE Жыл бұрын
Thanks so much for watching the video and sharing your valuable comments here. Please stay in touch for more such videos on my channel and don't forget to subscribe.
@juanfrancisco285
@juanfrancisco285 2 жыл бұрын
STARTING EARLY IS THE BEST WAY OF GETTING AHEAD TO BUILD WEALTH, AND INVESTING REMAIN A PRIORITY. THE STOCK MARKET HAS PLENTY OF OPPORTUNITY TO EARN A DECENT PAYOUTS, WITH THE RIGHT SKILLS AND A PROPER UNDERSTANDING OF HOW THE MARKET WORKS
@valeriavalentina5696
@valeriavalentina5696 2 жыл бұрын
That's true, most people today are seeing a lot of failures in forex and crypto sector due to poor orientations and bad experts.
@luisamarina6429
@luisamarina6429 2 жыл бұрын
Talking about Stocks, Forex and Cryptocurrency trading is the most profitable venture I ever invested in.
@Velereonics
@Velereonics 2 жыл бұрын
Shut up please ty
@JenniferBatsios-db7kv
@JenniferBatsios-db7kv Жыл бұрын
Thank you for this! I watched a few other videos that were so confusing, I got it instantly with your video - saved me so much time and manual lookups!
@ExceltoExcelE
@ExceltoExcelE Жыл бұрын
Thank you Jennifer for taking the time to write this note, I hope you will stay in touch with my channel for more such videos.
@berylroy6356
@berylroy6356 5 жыл бұрын
hello sir, you teach so well and i could understand it perfectly. pls keep going❤️
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Really happy that this video was useful for you and you enjoy my videos. Thanks alot for sharing your comments, stay tuned for more such videos.
@anandababu.m9561
@anandababu.m9561 3 жыл бұрын
Hello Sir, Your video on Vlookup is really helpful. Thanks a lot. I want to know the basics and all the technical aspects of the MS office and excel Kingsoft spreadsheets.
@sparty710
@sparty710 4 жыл бұрын
Thanks, best clear vLookup video I've seen!
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks alot Trevor for watching and sharing your comments, please stay tuned for more such videos.
@fayekeller7411
@fayekeller7411 6 жыл бұрын
Love the teaching method, very precise. Question how do you copy the VLook function to fill the sequence in the column you've selected?
@rilwana.abiodun725
@rilwana.abiodun725 2 жыл бұрын
Just drag it down from your main answer to see the rest.
@jessicastafford5535
@jessicastafford5535 3 жыл бұрын
When I tell you I have been in accounting for 7 years and never used VLookup because I didn’t want to take the time to understand it… I even told my coworkers nope, not doing that, a million times. It was the running joke that I’m the accountant who hates excel. And I owned it. But now I work for myself and I have to figure this shit out. Thank you, sir.
@ExceltoExcelE
@ExceltoExcelE 3 жыл бұрын
Glad you enjoyed it! and I am really excited to see a professional's point of view on the subject. I take it as a very big compliment and I am so happy that I could be useful by any means to you. you made my day. thanks alot for sharing your comments , please say in touch for more such videos.
@kaleshh6988
@kaleshh6988 6 жыл бұрын
Thank you soomuch sir.. Good teaching.. Nice explanation.. Nice example.. Keep gooing..
@ExceltoExcelE
@ExceltoExcelE 6 жыл бұрын
Thanks alot for such wonderful and motivating feedback, I am glad you liked and enjoyed the video
@xlsdeal
@xlsdeal 5 жыл бұрын
KALESH H kzbin.info/www/bejne/r4GWc4SbfrF-mqs Did You forget your excel sheet password. This link helps you.
@MS-kd9fd
@MS-kd9fd 4 жыл бұрын
Excellent description and example!
@ExceltoExcelE
@ExceltoExcelE 4 жыл бұрын
Thanks for watching the video and your comments, please stay in tune for more such videos.
@nikhilec3135
@nikhilec3135 5 жыл бұрын
you are a good teacher
@ExceltoExcelE
@ExceltoExcelE 5 жыл бұрын
Thanks alot Nikhil for the note and watching the video. I am glad that it was useful and you liked it. Please stay in touch for more such videos
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 347 М.
Excel Vlookup Tutorial - Everything You Need To Know
21:50
Excel Campus - Jon
Рет қаралды 2,6 МЛН
The Best Band 😅 #toshleh #viralshort
00:11
Toshleh
Рет қаралды 22 МЛН
UFC 310 : Рахмонов VS Мачадо Гэрри
05:00
Setanta Sports UFC
Рет қаралды 1,2 МЛН
Excel PivotTables for Beginners (2025)
9:59
Excel University
Рет қаралды 91 М.
Advanced Excel - VLOOKUP Basics
11:58
Technology for Teachers and Students
Рет қаралды 2,2 МЛН
Compare Two Lists Using the VLOOKUP Formula
12:49
Computergaga
Рет қаралды 2,9 МЛН
VLOOKUP in Excel | Tutorial for Beginners
32:09
Kevin Stratvert
Рет қаралды 2,1 МЛН
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 567 М.
How to Use VLOOKUP to Compare Two Lists
15:20
Simon Sez IT
Рет қаралды 888 М.
The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)
12:44
Kenji Explains
Рет қаралды 436 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 8 МЛН
The Best Band 😅 #toshleh #viralshort
00:11
Toshleh
Рет қаралды 22 МЛН