don't mind me 1:44 normal vlookup 6:29 vlookup from different sheet 8:00 vlookup from different workbook 9:25 copy vlookup formula 11:46 vlookup multiple values at once 14:20 vlookup smallest value 15:25 vlookup largest value
Vlookup has been explained in the easiest way following step by step basis. The Teacher is one of the best communicators I have come across. Kind Regards.
I only use Excel for my business to make a cash book and an attendance tracker for my students so I'm not that good at it. I needed to use this formal and this video has been the only one that worked for me. Thank you very much!
at 12:24 Rather than ColumnS($Q$3:R3), if we just type COLUMN(R3), that will also do the job, I suppose. I have tried it many times and it has worked well but I am not sure whether there are any disadvantages of this method. When you try this method, make sure that you use the Column function (without S at the end), not the ColumnS funtion. I should also note that it is an amazing video. I particularly liked vlookup from a different workbook. That is something that I have never thought of before. Thanks indeed.
Thank you sir.. I trying to learn from so long time... Refered so many vedioes.. But it will not help me... I seen your vedio... I clear understand and I tried... It's really helpful... Thanks a lot sir
Just woww,, this video made my day because I was a bit confused in Vlookup formula methods but now it's very clear, it's a very very helpful video to understand Vlookup in a very easy way thanks a lot 🙏
Thanks a lot for the great lesson. I have a question. What's the difference between using Vlookup to find the MIN/MAX and using MIN/MAX function directly?
MIN and MAX are numerical functions: that is, they won't work with text. So if you needed to identify the lowest or highest *score*, you'd use them by themselves. However, if you wanted to return not the score but the *student's name*, you'd need a VLOOKP.
Very informative! I’m just wondering what formula is used to extract or copy same names from different sheets? What I’m doing is like copy all wolverines from all tabs and paste them in a new one so that all wolverines will all show in the same new sheet. Thank you in advance!
Sir..this is one of the easier dan faster way to understand what's the VLOOKUP's function..Thank you so much for this video..Really appreciated it especially when it comes to copy this multiple values ..Tq so much
Thanks for video how to get multiples values on vlook up value for example I got part having different locations we need all locations to be displayed in one cell for the part ?can you please help
Hallo. Great video. Really helped me with my job. Unfortunalty still struggle with doing multyple values form different workbook. Looks like ,,columns,, option doesnt work for me. Wish You the best
Very thankful, appreciate the effort and support. I tried lot of videos to get an idea behind this, but I couldn't get it right. Only your video helped me at least to sort something out, I am very beginner in excel, but now also i cant use vlookup in another sheet of same excel. It's showing some errors.
for the last two methods, only min and max can be used, rather than using vlookup with min or max, there are other ways to use min and max for look up value to be found in array, which you have not mentioned here.
Thank you for this video! It helped me with a problem that I was working on with a spreadsheet. Your narration is delightful, it actually calmed me down and helped me retain the information. :)
Hello sir, thank you so much for this ...could you please help me out with this " copy vlookup formula" , after removing the dollar sign from row still its not copied the formula i have tried so many times but still unable to apply this.
Sir from 13:33 locking the column not the row i couldn't understand... Can you explain it briefly because when I'm doing copy paste in other three columns it is showing NA why ?
HI, thanks for this informative video. i anted to ask that when i tried vlookup from another worksheet and i pressed f4, no dollar symbol came but it worked still. why is that?
Truely explained in a simple way..Thanks a lot. Would like to know one thing ..when the data of reference value table is deleted..the data returned in the sheet is also deleted. How to go about wt it
I need auto word suggestions tool to suggest words by looking up the entire sheet. I mean if A1, B2, and many others have multiple words in them, and when I write a word in a new cell from the words that are already used in the sheets, I want the tool to suggest that.
This is a very good video - Thank you!!! It was very easy to follow you and understand the idea behind this formula. Just one thing was not explained and I had to go to other videos in order to understand it. This was the 0 in the formula at the end prior to closing the brackets. I learned that 0 or "False" is added when you want the vlookup formula to return an exact value from the table and column where we need information from.
Hi .. thank you for the video... please help me with one more info...so these children wrote retest and their marks are also just below.. how do I choose the max marks they got in one subject.....
What if I want to refer to a table that is regularly getting information added in so that the limits of the tables are regularly changing? Do I just select the entire column rather than limit it to the last cell of that column? Sorry if my wording is confusing
Hello sir, Your this video is superb.. explained in very easy and friendly manner. Thanks a ton. But I have one query. I have suppose 100 rows to lookup for. But my other sheets dont include all he 100 rows. Some sheets have few and other sheets have few other rows. But i want to club all the rows and look for the value from particular one column of these range sheets. But m not getting expected results... where m doing wrong... is it possible to you to tell.? And did u get what i wann ask and what kind of data i have and what result m expecting?
I really appreciate your help, thank you very much! On my excel I have Purchase & Sale column together. Purchase can be in cash & in Credit & also the same way Sale can be in cash & in Credit. Now I need to get total credit in purchase & total credit in Sale. The same to credit for sale. Can I do this with this function?? Or shall I send you please?
useful video just help me in use of formula multiple values at once, if i want to pick any value in between (not in sequence) how can it be done pls help
Do you have a video showing how to do a vlookup with visible cells only (ignoring hidden rows) and how to copy the vlookup formula in the visible cells only.
I have a question, are the tables should be in same format from other sheets or other files? if so what is the format it should be or in which format we have to convert the data and start applying VLOOKUP?
great tutorial. sir i need vlookup for inventry like (product code is 1 and product name is chair) so if i select product code 1 the product name chair automatically mention and come.please kindly help me..
don't mind me
1:44 normal vlookup
6:29 vlookup from different sheet
8:00 vlookup from different workbook
9:25 copy vlookup formula
11:46 vlookup multiple values at once
14:20 vlookup smallest value
15:25 vlookup largest value
Thanku bhai
Thanks
This is first video, where I could understand how to use vlookup. I watched so many videos, I wasn’t able to understand it.
Thank you so much.
Thank you. To see our latest videos please visit www.myelesson.org/
Vlookup has been explained in the easiest way following step by step basis. The Teacher is one of the best communicators I have come across. Kind Regards.
you can see it. th-cam.com/video/rVDhZuIdjE4/w-d-xo.html
I only use Excel for my business to make a cash book and an attendance tracker for my students so I'm not that good at it. I needed to use this formal and this video has been the only one that worked for me. Thank you very much!
So u r accountant🤔
Omg cutie pie 🥰
at 12:24
Rather than ColumnS($Q$3:R3), if we just type COLUMN(R3), that will also do the job, I suppose. I have tried it many times and it has worked well but I am not sure whether there are any disadvantages of this method.
When you try this method, make sure that you use the Column function (without S at the end), not the ColumnS funtion.
I should also note that it is an amazing video. I particularly liked vlookup from a different workbook. That is something that I have never thought of before. Thanks indeed.
I wonder, why must it be the first two columns only -- why not STUDENT NAME and all the way to HISTORY?
thanks dear I tried your suggestion and it really works thanks a lot
Thank you sir.. I trying to learn from so long time... Refered so many vedioes.. But it will not help me... I seen your vedio... I clear understand and I tried... It's really helpful... Thanks a lot sir
Great stuff! The best video ever on Vlookup. You made it look so simple, I learnt all 7 ways in just one view. Thanks a lot
Nafaah Osman from Ghana. Orderly and systematic presentation, you are indeed a GURU for you have made my day
I really valued your videos, I have been searching for multiple vlookups function, now I have cleared it from your video. Thanks Bro.
how i learned so much from this tutorial! keep posting informative vids in esp. excel.
Thank you. To see our latest videos please visit www.myelesson.org/
Just woww,, this video made my day because I was a bit confused in Vlookup formula methods but now it's very clear, it's a very very helpful video to understand Vlookup in a very easy way thanks a lot 🙏
You saved me. Keep on getting error in working on different sheet because i keep using False! Instead, you used, "0" and it worked. Thanks a lot!
One of the best vlook video on internet.. all ways described very precisely.
Glad you liked it!!
Just at 3:42 minutes and I am liking the way of explaining. It is like a friend sitting next and explaining. :)
For VLook up min and MAx. We can directly go for the formula min or max right. In this case how is a VLook up min max different.
Love you sir, your teaching i loved it. As though you are teaching to your own children.... God bless you
Thank you for the kind words
This is really best way to learn Vlook up...Simple, and complete.. Really liked it.. Thanks
Thanks a lot for the great lesson. I have a question. What's the difference between using Vlookup to find the MIN/MAX and using MIN/MAX function directly?
MIN and MAX are numerical functions: that is, they won't work with text. So if you needed to identify the lowest or highest *score*, you'd use them by themselves. However, if you wanted to return not the score but the *student's name*, you'd need a VLOOKP.
Very informative! I’m just wondering what formula is used to extract or copy same names from different sheets? What I’m doing is like copy all wolverines from all tabs and paste them in a new one so that all wolverines will all show in the same new sheet. Thank you in advance!
My E-Lesson
• 2 days ago
Thank you. To see our latest videos please visit www.myelesson.org/
Ohh yes this is the video I hv been searching. Very helpful
This is probably the easiest explanation of vlookup I have ever come across till now.
Great Video. I have seen 10 more videos but at the end I was able to perform my assignment after watching this video only.
Many thanks for this video. I had an interview and this has really helped me.
Sir..this is one of the easier dan faster way to understand what's the VLOOKUP's function..Thank you so much for this video..Really appreciated it especially when it comes to copy this multiple values ..Tq so much
I cannot appreciate your videos enough! They are just so good sir! Thankyou so much for spreading such positivity and your aura around through these.
Thank you. To see our latest videos please visit www.myelesson.org/
Thank you... You saved my lots of time.. God bless you
"Vlookup multiple values at once". Very super. I cleared my doubts and learned. Thank you, Sir.
Welcome
Thanks for video how to get multiples values on vlook up value for example I got part having different locations we need all locations to be displayed in one cell for the part ?can you please help
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
I just started using Vlookup and I love the examples. They were very helpful....thank you!
Hallo. Great video. Really helped me with my job. Unfortunalty still struggle with doing multyple values form different workbook. Looks like ,,columns,, option doesnt work for me. Wish You the best
the mention of absolute values using F4 solved my problem, thank you!
Very well explained I was searching it on different websites but wasn't able to find it It helped me just few hours ago before exams 😊
i want to tell u sir, trust me ur narration is very powerful n well understanding.
For smallest and largest values, we can simply use =Min(K4:K8), or =MAX(K4:K8). Why incorporate vlookup? Makes it complex.
Beacuse of that you didn't use lookup
Well said ,sir.I was also thinking the same
it is good to learn the things more than one way.
Sir, kindly elaborate further the terms used when looking for Min/Max for instance (K4:K8). Thanks
wkwkw
Learning something from you hits differently, hats off to you Vidushi☺️
This is the best Vlookup tutorial...
I have understand to a better extent...
Really really nice teaching...
Very thankful, appreciate the effort and support. I tried lot of videos to get an idea behind this, but I couldn't get it right. Only your video helped me at least to sort something out, I am very beginner in excel, but now also i cant use vlookup in another sheet of same excel. It's showing some errors.
for the last two methods, only min and max can be used, rather than using vlookup with min or max, there are other ways to use min and max for look up value to be found in array, which you have not mentioned here.
Amazing👍 vlookup multiple values just saved my day!
the way of teaching is awesome , sir i have one doubt please clarify on this
Vlookup multiple smallest values at once ,please suggest
I never saw such an easy explanation of vlookup. Thank you sir ❤
Brother you have simplified VlookUp so well :) .. You are doing an awesome job and helping so many of us.
This was an Excellent video to know Vlookup for any beginner..
Good,Crystal clear explanation! Kindly share Pivot table link same like as. Thanks
Thank you for this video! It helped me with a problem that I was working on with a spreadsheet. Your narration is delightful, it actually calmed me down and helped me retain the information. :)
Hello sir, thank you so much for this ...could you please help me out with this " copy vlookup formula" , after removing the dollar sign from row still its not copied the formula i have tried so many times but still unable to apply this.
we will get back to you very soon.
Thank you. To see our latest videos please visit www.myelesson.org/
Very simple and easy to understand.
Indeed very helpful.
Thank you
Best tutorial I've seen. Thanks.
Very nice teaching. It's so much helpful for who don't have any basics idea in vlookup 👍.
#5 is very important functions. THANK YOU SO MUCH!!!!!
You are a good trainer even here 2021 still find this so helpful.
Thank you
The GURU has proved himself.
Sir what have you done after sparklines in multiple times at once topic ?
Sir from 13:33 locking the column not the row i couldn't understand... Can you explain it briefly because when I'm doing copy paste in other three columns it is showing NA why ?
Excellent teaching way specially for beginner thanks
HI, thanks for this informative video. i anted to ask that when i tried vlookup from another worksheet and i pressed f4, no dollar symbol came but it worked still. why is that?
it was needed to me. Now I have learnt. Thank You so much.
Truely explained in a simple way..Thanks a lot. Would like to know one thing ..when the data of reference value table is deleted..the data returned in the sheet is also deleted.
How to go about wt it
thankyou so much for the video i was confused by all the video urs was easier to understand and it worked for me
It will save my time a lot...especially multiple column part .....thanks a lot
Can't thank you enough for this
Found no ease in learning lookup formulas other than here
So impressing and helpful video. Thank you so much!
Helped a lot.
How to find which student got least value if we do not know neither
I need auto word suggestions tool to suggest words by looking up the entire sheet. I mean if A1, B2, and many others have multiple words in them, and when I write a word in a new cell from the words that are already used in the sheets, I want the tool to suggest that.
Thank you for help brother, you explain them very well, God bless you.
superb teaching,Thank you so much sir,love from Bangladesh
I like the way you have explained.. it is easily understandable
This is a very good video - Thank you!!! It was very easy to follow you and understand the idea behind this formula. Just one thing was not explained and I had to go to other videos in order to understand it. This was the 0 in the formula at the end prior to closing the brackets. I learned that 0 or "False" is added when you want the vlookup formula to return an exact value from the table and column where we need information from.
Hi .. thank you for the video... please help me with one more info...so these children wrote retest and their marks are also just below.. how do I choose the max marks they got in one subject.....
Super clear explanation 💚 thanks from sri lanka
Great video sir very thankfull now i know the Vloopup functions are very powerfull 😊
Thank you for putting this video out and communicating the use case and lesson so well
It's really very useful vedio to learning excel people, thank you very much sir
thank you sir............. you really make others to understand the subject....
Hi thanks for the video. I can’t lock the cell with f4 please comment
What if I want to refer to a table that is regularly getting information added in so that the limits of the tables are regularly changing? Do I just select the entire column rather than limit it to the last cell of that column? Sorry if my wording is confusing
Hello sir,
Your this video is superb.. explained in very easy and friendly manner. Thanks a ton.
But I have one query. I have suppose 100 rows to lookup for. But my other sheets dont include all he 100 rows. Some sheets have few and other sheets have few other rows. But i want to club all the rows and look for the value from particular one column of these range sheets. But m not getting expected results... where m doing wrong... is it possible to you to tell.?
And did u get what i wann ask and what kind of data i have and what result m expecting?
Thanks a lot for the Valuable tutorial section.
If the required values in different columns(like in T, W, Z columns) rather than in side by side columns, what is the syntax.??
I really appreciate your help, thank you very much! On my excel I have Purchase & Sale column together. Purchase can be in cash & in Credit & also the same way Sale can be in cash & in Credit. Now I need to get total credit in purchase & total credit in Sale. The same to credit for sale. Can I do this with this function?? Or shall I send you please?
we will get back to you
Thank you. To see our latest videos please visit www.myelesson.org/
useful video just help me in use of formula multiple values at once, if i want to pick any value in between (not in sequence) how can it be done pls help
Thank you sir, the way you teach reminded me of my math teacher in school.
Do you have a video showing how to do a vlookup with visible cells only (ignoring hidden rows) and how to copy the vlookup formula in the visible cells only.
Thank you for this video and the way you r teaching is awesome
awsm video with great vlook up knowldege. but what if in class there are 2 jim and 3 Micky? Please help
thank you sir for explaining vlookup function on such a great way.. Now all my doubts are gone
Excellent speech i learnt alot from u which is usefull to my future thanq so much
Thanks
I have a question, are the tables should be in same format from other sheets or other files? if so what is the format it should be or in which format we have to convert the data and start applying VLOOKUP?
Superb,simply superb.Sir can u plz upload a video on using vlookup in Google Sheets as well.
Thank you very much for the information.your sessions really helped me alot.
great tutorial. sir i need vlookup for inventry like (product code is 1 and product name is chair) so if i select product code 1 the product name chair automatically mention and come.please kindly help me..
hi sir, thanks for the lesson, but practice file is missing, if its their it will be more help full to practice
Superb great teaching skills thank you for the video
Thank you for this video Guru.☺️☺️👍👌
Sir agar array have some other words also. Will vlookup work?
Most effective and easiest way of teaching 👌
Guruji,
Before my comment, you had already century. I just want to add pretty much similar to others, you taught fantastic. Thanks.
Thank you very much sir, it's help me a lot to improve my excel advance way.
Super master the video was very very informative and brilent thank you very much Brother keep upload the videos
I can really very useful video to me.... Thank you so much sir🤝