Thank you guys viewing this video more than 1M times. Tutorials Point will continue bringing such great videos to our viewers. Thanks again from Tutorials Point Team.
Thanks for your video! I’ve had a hard time learning how to use Excel, but this video cleared up several doubts for me. I do have one problem, though, my product key seems to be damaged because the programs aren’t opening like they used to. Any help would be appreciated. Thanks again!
If your product key seems to be damaged, you might want to try reaching out to the support team where you originally got it. Alternatively, you could consider getting a new key from a trusted source like bhn software. They offer reliable keys and customer support. Hope this helps!
I tied many videos to understand this concept, but hands down this is the best one. within 5 mins I was able to do VLOOKUP with data validation as well. Thankyou so much !
I used to watch your short courses along time ago , but I came here 2023 to thank for you for this specific lesson related the VLOOKUP , which was so helpful to me today.
I was stuck in a multiple sheets workbooks. My method took me almost 1 hour of my precious time. Thanks to this video I saved tons of time using vlookup.
Sir your explanation makes me understand very easily . Recently I have enrolled to one of your tableau course on 49 charts in Udemy. It's amazing Sir. Thanks for such a nice teaching and helping the jobseekers.
I have watched a few videos to learn about V and H Lookup but your explanation is more understandable to me. Other's are a bit too complicated. Thanks.
Your communication skills are absolutely outstanding and you have a broad knowledge in computers sir. Each one of them who hqve commented below in the comment section are indeed gaining a lot of knowledge from you sir. Quite impressed with you sir. Keep uploading videos and keep moving forth ❤😊
This is the kind of tutorial im looking for, short and precised.. first time to vlookup but you made it easy for me to understand and perform.. thank you sir!
Thank you for this clear explanation. I have been asked to explain vlookup to someone and your clear demonstration is excellent, well done. Keep learning, and keep being as good as this. Thank you!
Tq so much sir as I scared so much about learning vlookup but by watching this video I have gained confidence ... Tq so much u it was a crystal clear explanation....
This was amazing. To the point and also including some more advanced functions to really make it easy! I speak for many of your viewers when I say that you made my job a lot easier!
Hi Sangeeta. If you got it then do help me with my query if possible. At 3.38, why it comes to 20.95 only? When I tried it comes to $20.95 and not 20.95. How come it gets only 20.95 without any Dollar Sign ?
Amazing. very crisp and clear, to the point and well prepared training. I really like you're touch screen training method. thank you once again. I have learned so much in just one video.
godwin peter bro that is not a formula instead its the range or shall i say the address of that particular cell. Once clicked this cell address gets locked as in this case its C1, A4 ( cell location)
Thank you for taking the time to us. I sincerely appreciate the time you spent to explain the class and the way you have explained it in the video was excellent. Your video was very helpful for the students, unemployed youth. Once again we thank you heartily for being a part of raising a great nation.
You are a good trainer. Even the tools and platform used to present the video tutorial is excellent. Easy to grasp and that too the number of other concepts and possibilities introduced, is amazing. Very good sir.
Very well detailed explanation in easiest way .... I noted many of my colleagues not able to use this feature but your video made them use that very efficiently
Thank you Mr. Pavan Lalwani for this lecture. Today, I was able to apply VLOOK after going thru your tutorial to identify and solve a key business problem. I am interested to take further lessons from you. Thanks again.
Pavan, Your presentations are very professional. I am new to UFT but in my workplace, I got great recognition because of you. Few weeks back they asked me to start using UFT. I looked at QTP in 2011, that too for a week and left. So basically no knowledge about it. I started watching your videos and started working on my application and created several scripts. Total team was appreciating me. It is just because of you. Thank you so much. I need a small help. We are using windows based application. We need to upload some files from different folders. When clicking back and forth, the application is recording it as (Window("TEST").Window("Select File to Attach").Click). When I navigate to different folders, it is creating several steps but they all look same. Is there a way to add a file path, like C:\Users\xxx\FolderName\File.txt If there is anyway to select a file based on the path. Please let me know. Thanks again for your wonderful work.
Vertical lookup works only on the first column of the table... This was missed in this video, which I wrongly tried for random entry in table and I could not make up. JYI
Importantly, VLOOKUP can only look to the right. The data you want to retrieve (result values) can appear in any column to the right of the lookup values.
Much appreciated for your guidance sir, this video had been really helpful for me. I literally had trouble understanding vlookup but this video made me understand it so clearly and concisely.
If I have more than 10,000 nos of products in my shop, I don't have much time to drop-down the list and scroll down the mouse wheel and pick the exact product while billing. Here what am looking for, if I set item code/part number to each of them like 1, 2, 3.....9999, 10000. And on my invoice format I allotted sl.no, item code, product description, rate, quantity and amount in cell wise respectively. How do I get 'product description & rate' by just typing the item code? Pls make an another video about this matter.
@@hrithikraj4927 sorry to say this bro... Your video is too not give the solution for my question. If you have time pls read my question again and make a clear video on it. (I'm subscribed your channel, hope you'll clear my doubt)
Appreciate your dedication and lovely presentation, it really helped me to understand the lookups well. Keep this great work up. You are doing what a well- known education university could not.
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
Finally Sonu Nigam had to come to teach me Excel.
😂😂🤣
lol
😂😂Right you are
LoL 😂
😂😀😎
Thank you sir for really nice content.
Thank you guys viewing this video more than 1M times. Tutorials Point will continue bringing such great videos to our viewers. Thanks again from Tutorials Point Team.
Bro it's pretty good, but I'm facing a problem coz lookup values is repeating in column and I want all sum of all values of required lookup values
In a same way can we transfer the html data suppose in stead of value there is a html data in the form of attachment how to transfer that
@@vineetkumarchaudhary5865 you need to understand the Freeze element
Bro how that B15 come
How you are making the visualization of this Video?
Thanks for your video! I’ve had a hard time learning how to use Excel, but this video cleared up several doubts for me. I do have one problem, though, my product key seems to be damaged because the programs aren’t opening like they used to. Any help would be appreciated. Thanks again!
If your product key seems to be damaged, you might want to try reaching out to the support team where you originally got it. Alternatively, you could consider getting a new key from a trusted source like bhn software. They offer reliable keys and customer support. Hope this helps!
I had the same problem, and I just checked out the website you recommended. It helped me fix it. Thanks!
Thanks! It helped me solve the issue, and now I can use Excel without any problems!
You can also use cloud excel from Microsoft for practice.
I tied many videos to understand this concept, but hands down this is the best one. within 5 mins I was able to do VLOOKUP with data validation as well. Thankyou so much !
First time in my life I can say now to interviewer that I know everything about vlookup. Thanx
ua-cam.com/video/Jho4h3xthGE/v-deo.html
@@SantoshGupta-bh7lv please take a breath
Same for me..... Bro
Dude.. move out for a walk in intervw u'll understand what hav u learned..excel is not so easy u nid a heck of a practice bruh... Ol d bst
ua-cam.com/video/o3DyJnZY7KU/v-deo.html
This is the art of explaining complex things easily. Excellent Sir
I used to watch your short courses along time ago , but I came here 2023 to thank for you for this specific lesson related the VLOOKUP , which was so helpful to me today.
SINCE THE SCREEN IS NOT PROPERLY VISIBLE, YOUR POINTING ON THE RELATED CELL WHILE VERBALLY NARRATING BECAME VERY HELPFUL.
I was stuck in a multiple sheets workbooks.
My method took me almost 1 hour of my precious time.
Thanks to this video I saved tons of time using vlookup.
All the best :)
ua-cam.com/video/2Y7434Xia5Q/v-deo.html
Please see this vedio "What is Algo Trading"==ua-cam.com/video/Jho4h3xthGE/v-deo.html
I'm stuck again.
I want to fetch a value that matches 2 colum, of exact value.
how should i do it?
Sir, you are brilliant! Perfect explanation, straight to the point and easy to comprehend. Video explanation is short and sweet!
Thank you :)
TO BE HONEST I HAVE SEEN LOTS OF TEACHER U R ONE OF THE BEST
Sir your explanation makes me understand very easily . Recently I have enrolled to one of your tableau course on 49 charts in Udemy. It's amazing Sir. Thanks for such a nice teaching and helping the jobseekers.
Can you send me the link of that course ?
I have watched a few videos to learn about V and H Lookup but your explanation is more understandable to me. Other's are a bit too complicated. Thanks.
www.youtube.com/@user-io3rz7by2g?sub_confirmation=1
For informative excel videos
You are an absolute legend!
Explained precisely to the point!
Thank you so much, I was never able to grasp Excel formulas quickly this would be the 1st!
i seriously love how this dude teaches
It amazes me how you simplify what seemed complex. Thank you Sir
The best VLOOKUP with data validation explanation ever! Many thanks Pavan!
Thank you so much. You have made it so simple. Prayers and Respect from Pakistan !
You r the best teacher,well described from A-Z with different options ,salute to you sir.
Your communication skills are absolutely outstanding and you have a broad knowledge in computers sir. Each one of them who hqve commented below in the comment section are indeed gaining a lot of knowledge from you sir. Quite impressed with you sir. Keep uploading videos and keep moving forth ❤😊
I have seen alot videos to learn how to use Vlookup... But Finally I got the best ever video. Thank u so Much. It is realy Helpful
World No 1 channel to know about Exel❤❤❤❤
This is the kind of tutorial im looking for, short and precised.. first time to vlookup but you made it easy for me to understand and perform.. thank you sir!
ua-cam.com/video/rVDhZuIdjE4/v-deo.html
www.youtube.com/@user-io3rz7by2g?sub_confirmation=1
For informative excel videos
Dude, I love it. It’s really crucial for professionals
Thank you so much
Love you from 🇱🇰👍🏾👍🏾
The best tutor so far who i saw made look up easier ever . Thanks
The best video till now...with simple explanation....hats off to u sir.....saved me...tysm sir
Thank you for this clear explanation. I have been asked to explain vlookup to someone and your clear demonstration is excellent, well done. Keep learning, and keep being as good as this. Thank you!
Vlookup hlookup
ua-cam.com/video/66b_CMfD6rE/v-deo.html
Sir, your explanation is awesome.. your way of explaining every topic is so straight and simple🤗
This guy explains so well. Thank you. I keep watching it whenever i need to do any vlookup . Cheers mate ;)
Tq so much sir as I scared so much about learning vlookup but by watching this video I have gained confidence ... Tq so much u it was a crystal clear explanation....
love this guy literally saved me from exams best explained point to point better than the teacher
This was amazing. To the point and also including some more advanced functions to really make it easy! I speak for many of your viewers when I say that you made my job a lot easier!
Excellent and very effective teaching. Thank you so much for making us understand the concept perfectly!
Yes absolutely
Hi Sangeeta. If you got it then do help me with my query if possible.
At 3.38, why it comes to 20.95 only? When I tried it comes to $20.95 and not 20.95.
How come it gets only 20.95 without any Dollar Sign ?
What a clear and concise explanation! Crisp. Nicely done. Kudos. Thanks.
Hi I made one VLOOKUP tutorial in Hindi learn in 3mins, Simple. ua-cam.com/video/XDy8suXOJ7g/v-deo.html
Fantastic! Finally Sonu Nigam has showed up to teach me Vlookup.
Aye lecturer bohot sahi hai
Bohot easy se samjha Diya 😍
That's very well taught with simplicity, easy to learn this way. Thanks a lot!
Amazing. very crisp and clear, to the point and well prepared training. I really like you're touch screen training method. thank you once again. I have learned so much in just one video.
My Dear Friend ❣️...
Please Help to Subscribe : m.ua-cam.com/channels/qqx28rgTRzrT3_k7458h-g.html
You had precisely and clearly taught what is VLOOKUP and how to use it. Thank you so much
ua-cam.com/video/2Y7434Xia5Q/v-deo.html
Bro what is that formula C1,a4
godwin peter bro that is not a formula instead its the range or shall i say the address of that particular cell. Once clicked this cell address gets locked as in this case its C1, A4 ( cell location)
@@nishurocks2010 yes you are right that's the cell address
ua-cam.com/video/5NF5jCYnfok/v-deo.html
SIR YOU ARE A BEST TEACHER OF COMPUTER AND ENGLISH TOO....
That was THE most perfect tutorial I have ever seen. Amazing work man.
Thank you for taking the time to us. I sincerely appreciate the time you spent to explain the class and the way you have explained it in the video was excellent. Your video was very helpful for the students, unemployed youth.
Once again we thank you heartily for being a part of raising a great nation.
You are a good trainer. Even the tools and platform used to present the video tutorial is excellent. Easy to grasp and that too the number of other concepts and possibilities introduced, is amazing. Very good sir.
Thanks Ravikanth :)
www.youtube.com/@user-io3rz7by2g?sub_confirmation=1
For informative excel videos
Come here Sir we need people like you in Canada
You explain it easily and with best clarity so that we can understand and remember. Thank you somuch.
On the UA-cam this is best teacher in the World 🌎
very easy to learn Vlookup formula from you sir. Its amazing God bless you
Thank you :)
Hi I made one VLOOKUP tutorial in Hindi learn in 3mins, Simple. ua-cam.com/video/XDy8suXOJ7g/v-deo.html
That's well taught with simplicity, easy to learn this way. thank you , very beneficial.
An excellent and effective way to teach. Thanks a lot.
Very well detailed explanation in easiest way ....
I noted many of my colleagues not able to use this feature but your video made them use that very efficiently
😲🤩😍 What an experience of teaching. Very good explanation and easy to understand.
Quick, easy, to the point, accurate, ❤️❤️
Overall excellent ✨
Imp to note this pt. also
The finding value should always kept in the first column of table array
Absolutely bro this gave me so much of hard time.. i came back only to see him miss this valuable point
watching this in 2024 🙂
Same
Bro 20 days left for 2025🥲
Finally someone taught vlookup clearly huhuhu. Thankyou!
Kudos to you! The clearest and easiest to understand Vlookup tutorial. Thank you!
THANK YOU SO MUCH I PASSED IN THE EXAM BECAUSE OF YOU.
Very eloquently explained. I have a doubt. When do we anchor the cells with '$' mark in the VLOOKUP function? What difference does it make?
we use '$' to lock in the cell if we didnt the range will just keep going down
I just love this sir's explanation. Expecting more videos . Very very clear explanation. Amazing
The quality of his teaching just fantastic 😊😊🖤❤
Given away so smoothly....No halla bulla (like they say "Cool"). Thank you.
Thank you Mr. Pavan Lalwani for this lecture. Today, I was able to apply VLOOK after going thru your tutorial to identify and solve a key business problem. I am interested to take further lessons from you. Thanks again.
I was so completely confused about this Look up thingy ...and now I am only a little bit confused! Thank you!!
Appreciate your explanation skills sir. Thank you so much for this video.
Thanks! Love your video. It’s so much easier to understand with your explanation. 👍🏻👍🏻👍🏻
First time, I have learned vlookup so easily. Thank you so much!! Love the way you explain things! ❤️
ua-cam.com/video/rVDhZuIdjE4/v-deo.html
Pavan, Your presentations are very professional. I am new to UFT but in my workplace, I got great recognition because of you. Few weeks back they asked me to start using UFT. I looked at QTP in 2011, that too for a week and left. So basically no knowledge about it. I started watching your videos and started working on my application and created several scripts. Total team was appreciating me. It is just because of you. Thank you so much. I need a small help. We are using windows based application. We need to upload some files from different folders. When clicking back and forth, the application is recording it as (Window("TEST").Window("Select File to Attach").Click). When I navigate to different folders, it is creating several steps but they all look same. Is there a way to add a file path, like C:\Users\xxx\FolderName\File.txt
If there is anyway to select a file based on the path. Please let me know. Thanks again for your wonderful work.
Oh bro your explanation was too good and easy ... conduct some sessions like this ... it would be amazing , looking forward 👌👍
omg this guy is amazing, finally I understood this vlookup
Thanks :)
Warm regards,
Amazing Guy :)
ua-cam.com/video/2Y7434Xia5Q/v-deo.html
Are you Serious... You made it so easy and so interesting to learn Excel. Awesome sir.
You are one of the excellent teacher in India.
Vertical lookup works only on the first column of the table... This was missed in this video, which I wrongly tried for random entry in table and I could not make up. JYI
Was experiencing the same.
Nice observation!
most useful for me sir you explain well and eazy to understand sir, thank you
Good explanation. Thankyou:)
You are a good person and after learning from you, you are my teacher.
Wow. Aapne to bahut simple tarike se sikhaya hai. Pehli baar main hi samaj main aaya
Thank you so much. Love from Pakistan.
My Pleasure brother
Tacticalieutenant abe thanks baad me bolna pehle tere Pakistan mein exel install to kara 😬 fir guns aur bombs ka vlook up Laga ke dekhna
My pleasure please avoid negativity
Perfect explanation, very easy to follow and adopt. Thank You!!!
Your process of teaching is amazing......I want to be your student.....
Well said
Now Vlookup is crystal clear to me. Thank You.
Your teaching skill is powerful and easily standable
Importantly, VLOOKUP can only look to the right. The data you want to retrieve (result values) can appear in any column to the right of the lookup values.
THANK YOU. Finally, finally, f i n a l l y got it done with help from this.
Thank u so much for the clear explanation on Vlookup....😃
My Pleasure :)
Hi I made one VLOOKUP tutorial in Hindi learn in 3mins, Simple. ua-cam.com/video/XDy8suXOJ7g/v-deo.html
Thank you so much sir, I had this doubts from so long & Now it's cleared within few minutes. Keep Growing ❤❤
Much appreciated for your guidance sir, this video had been really helpful for me. I literally had trouble understanding vlookup but this video made me understand it so clearly and concisely.
Thank you so much for the clear explanation every thing in MS Exel..........
If I have more than 10,000 nos of products in my shop, I don't have much time to drop-down the list and scroll down the mouse wheel and pick the exact product while billing.
Here what am looking for, if I set item code/part number to each of them like 1, 2, 3.....9999, 10000. And on my invoice format I allotted sl.no, item code, product description, rate, quantity and amount in cell wise respectively. How do I get 'product description & rate' by just typing the item code?
Pls make an another video about this matter.
Hi Karthick Sri, i have a perfect solution of your question. refer to my channel and find out the video in which i am explaining Vlookup function.
@@hrithikraj4927 mmmmm, sure. I'll watch and reply you bro.
@@hrithikraj4927 sorry to say this bro... Your video is too not give the solution for my question. If you have time pls read my question again and make a clear video on it. (I'm subscribed your channel, hope you'll clear my doubt)
Thanks for Subscribing my channel,
Ok i got your question and i will make sure to get the solution of your question.
@@hrithikraj4927 👍👍👍
U r better then my sir😄
Great Compliment buddy :)
I'm a big fan of u. Keep going. My work becomes easy with your help.
Your teaching method is really genuine and simple thanks ☺️😊
Sonu nigam jii ek gana ho jaye 😂😂😂
Why was i introduced to your channel so late ? Its so damn good and simple! Thanks but somehow my vlookup is not working, still trying :)
Thank you now, i see my way
Appreciate your dedication and lovely presentation, it really helped me to understand the lookups well. Keep this great work up. You are doing what a well- known education university could not.
Osm teaching ❤ loved it
Learnt easily
Tommorow is my practical
Mine is today
@@nihaal7750 :D
@@ReshmaMajumder it's over now I messed it up real bad :(
Mine is tomorrow, :)
@@ReduxMusic-qf5hk Best of luck then! Don't mess up!