7 Ways to Use Vlookup in Excel

  Рет қаралды 2,800,061

My E-Lesson

My E-Lesson

Күн бұрын

Пікірлер: 739
@maryamiffahabdulhamid2293
@maryamiffahabdulhamid2293 2 жыл бұрын
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
@riteshsingh508
@riteshsingh508 2 жыл бұрын
Thanku bhai
@maulanamohammedkhan2648
@maulanamohammedkhan2648 Ай бұрын
Thanks
@sumangaddu9963
@sumangaddu9963 2 жыл бұрын
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.
@GuruJii
@GuruJii 2 жыл бұрын
Thank you. To see our latest videos please visit www.myelesson.org/
@xaviervenancious778
@xaviervenancious778 4 жыл бұрын
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.
@shahzadakitchen
@shahzadakitchen 2 жыл бұрын
you can see it. kzbin.info/www/bejne/qIenmY2rfsmde5Y
@DogaF121
@DogaF121 3 жыл бұрын
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!
@rajneeshkumar328
@rajneeshkumar328 3 жыл бұрын
So u r accountant🤔
@hehzeus1764
@hehzeus1764 2 жыл бұрын
Omg cutie pie 🥰
@emrullahtan8695
@emrullahtan8695 6 жыл бұрын
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.
@bencitology1079
@bencitology1079 4 жыл бұрын
I wonder, why must it be the first two columns only -- why not STUDENT NAME and all the way to HISTORY?
@Filmy_Munch
@Filmy_Munch Жыл бұрын
thanks dear I tried your suggestion and it really works thanks a lot
@Reshma_S_Reshu
@Reshma_S_Reshu 3 жыл бұрын
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
@RamaChandraChessAcademy
@RamaChandraChessAcademy 4 жыл бұрын
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
@osmannafaah7635
@osmannafaah7635 3 жыл бұрын
Nafaah Osman from Ghana. Orderly and systematic presentation, you are indeed a GURU for you have made my day
@noboboro6782
@noboboro6782 4 жыл бұрын
I really valued your videos, I have been searching for multiple vlookups function, now I have cleared it from your video. Thanks Bro.
@harrietdomingo4132
@harrietdomingo4132 2 жыл бұрын
how i learned so much from this tutorial! keep posting informative vids in esp. excel.
@GuruJii
@GuruJii 2 жыл бұрын
Thank you. To see our latest videos please visit www.myelesson.org/
@zareenshonaa9949
@zareenshonaa9949 Жыл бұрын
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 🙏
@janinenabos3530
@janinenabos3530 4 жыл бұрын
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!
@sanyamjain2627
@sanyamjain2627 3 жыл бұрын
One of the best vlook video on internet.. all ways described very precisely.
@GuruJii
@GuruJii 3 жыл бұрын
Glad you liked it!!
@frankyfernandes6283
@frankyfernandes6283 7 ай бұрын
Just at 3:42 minutes and I am liking the way of explaining. It is like a friend sitting next and explaining. :)
@sundararam211
@sundararam211 4 жыл бұрын
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.
@omanabaiju6519
@omanabaiju6519 2 ай бұрын
Love you sir, your teaching i loved it. As though you are teaching to your own children.... God bless you
@GuruJii
@GuruJii 2 ай бұрын
Thank you for the kind words
@sunilp948
@sunilp948 4 жыл бұрын
This is really best way to learn Vlook up...Simple, and complete.. Really liked it.. Thanks
@fanyang2365
@fanyang2365 3 жыл бұрын
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?
@bordershader
@bordershader 2 жыл бұрын
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.
@owenhamz07
@owenhamz07 2 жыл бұрын
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!
@GuruJii
@GuruJii 2 жыл бұрын
My E-Lesson • 2 days ago Thank you. To see our latest videos please visit www.myelesson.org/
@dimpalsarma2449
@dimpalsarma2449 2 жыл бұрын
Ohh yes this is the video I hv been searching. Very helpful
@ashishh1323
@ashishh1323 2 жыл бұрын
This is probably the easiest explanation of vlookup I have ever come across till now.
@talhahussain4142
@talhahussain4142 Жыл бұрын
Great Video. I have seen 10 more videos but at the end I was able to perform my assignment after watching this video only.
@vinithageorge613
@vinithageorge613 2 жыл бұрын
Many thanks for this video. I had an interview and this has really helped me.
@Tengku_Hayder
@Tengku_Hayder 4 жыл бұрын
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
@sudlol
@sudlol 2 жыл бұрын
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.
@GuruJii
@GuruJii 2 жыл бұрын
Thank you. To see our latest videos please visit www.myelesson.org/
@shankrukulkarni3234
@shankrukulkarni3234 2 жыл бұрын
Thank you... You saved my lots of time.. God bless you
@p.aravindakashanmenon5743
@p.aravindakashanmenon5743 4 жыл бұрын
"Vlookup multiple values at once". Very super. I cleared my doubts and learned. Thank you, Sir.
@GuruJii
@GuruJii 4 жыл бұрын
Welcome
@dreambigservicesdreambig8372
@dreambigservicesdreambig8372 2 жыл бұрын
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
@GuruJii
@GuruJii 2 жыл бұрын
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
@darlenebradley5827
@darlenebradley5827 3 жыл бұрын
I just started using Vlookup and I love the examples. They were very helpful....thank you!
@usanve8335
@usanve8335 2 ай бұрын
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
@stardomee
@stardomee Жыл бұрын
the mention of absolute values using F4 solved my problem, thank you!
@syedamaira2172
@syedamaira2172 Жыл бұрын
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 😊
@ramdeepakvanam2159
@ramdeepakvanam2159 7 ай бұрын
i want to tell u sir, trust me ur narration is very powerful n well understanding.
@arwvirtualacademy5644
@arwvirtualacademy5644 4 жыл бұрын
For smallest and largest values, we can simply use =Min(K4:K8), or =MAX(K4:K8). Why incorporate vlookup? Makes it complex.
@silentanonymous1549
@silentanonymous1549 3 жыл бұрын
Beacuse of that you didn't use lookup
@gokulakrishnanr8802
@gokulakrishnanr8802 3 жыл бұрын
Well said ,sir.I was also thinking the same
@samirmistry5666
@samirmistry5666 Жыл бұрын
it is good to learn the things more than one way.
@abdullahidiqaa1673
@abdullahidiqaa1673 Жыл бұрын
Sir, kindly elaborate further the terms used when looking for Min/Max for instance (K4:K8). Thanks
@Elfass_
@Elfass_ 11 күн бұрын
wkwkw
@proudkumauni6988
@proudkumauni6988 Ай бұрын
Learning something from you hits differently, hats off to you Vidushi☺️
@derrickthedon91
@derrickthedon91 4 жыл бұрын
This is the best Vlookup tutorial... I have understand to a better extent... Really really nice teaching...
@jo4860
@jo4860 2 жыл бұрын
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.
@usamaathar3144
@usamaathar3144 4 жыл бұрын
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.
@mohangaikwad7263
@mohangaikwad7263 3 жыл бұрын
Amazing👍 vlookup multiple values just saved my day!
@tripatipadhy8669
@tripatipadhy8669 3 жыл бұрын
the way of teaching is awesome , sir i have one doubt please clarify on this Vlookup multiple smallest values at once ,please suggest
@FitUp-vr3ym
@FitUp-vr3ym 5 ай бұрын
I never saw such an easy explanation of vlookup. Thank you sir ❤
@vikramjitmitra
@vikramjitmitra 4 жыл бұрын
Brother you have simplified VlookUp so well :) .. You are doing an awesome job and helping so many of us.
@muralishankar9719
@muralishankar9719 3 жыл бұрын
This was an Excellent video to know Vlookup for any beginner..
@texganesh
@texganesh 2 жыл бұрын
Good,Crystal clear explanation! Kindly share Pivot table link same like as. Thanks
@neenareadsalot7563
@neenareadsalot7563 3 жыл бұрын
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. :)
@anuradhasrivastva5164
@anuradhasrivastva5164 2 жыл бұрын
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.
@GuruJii
@GuruJii 2 жыл бұрын
we will get back to you very soon. Thank you. To see our latest videos please visit www.myelesson.org/
@alicerong6095
@alicerong6095 2 жыл бұрын
Very simple and easy to understand. Indeed very helpful. Thank you
@labadventurestechnologies1400
@labadventurestechnologies1400 Жыл бұрын
Best tutorial I've seen. Thanks.
@vasanthreddy4687
@vasanthreddy4687 3 жыл бұрын
Very nice teaching. It's so much helpful for who don't have any basics idea in vlookup 👍.
@yanwang5788
@yanwang5788 Жыл бұрын
#5 is very important functions. THANK YOU SO MUCH!!!!!
@Caersy
@Caersy 3 жыл бұрын
You are a good trainer even here 2021 still find this so helpful. Thank you
@tafadzwamherekumombe2825
@tafadzwamherekumombe2825 3 жыл бұрын
The GURU has proved himself.
@toptech5384
@toptech5384 2 жыл бұрын
Sir what have you done after sparklines in multiple times at once topic ?
@swatimittal2040
@swatimittal2040 2 жыл бұрын
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 ?
@naumanfakharr5856
@naumanfakharr5856 Жыл бұрын
Excellent teaching way specially for beginner thanks
@fatimazaim503
@fatimazaim503 10 ай бұрын
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?
@abdulnabi6564
@abdulnabi6564 3 жыл бұрын
it was needed to me. Now I have learnt. Thank You so much.
@vaishalimhatre4477
@vaishalimhatre4477 4 жыл бұрын
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
@mkgowda-gb9no
@mkgowda-gb9no 3 жыл бұрын
thankyou so much for the video i was confused by all the video urs was easier to understand and it worked for me
@johnsingh2780
@johnsingh2780 4 жыл бұрын
It will save my time a lot...especially multiple column part .....thanks a lot
@infinitestories06
@infinitestories06 2 жыл бұрын
Can't thank you enough for this Found no ease in learning lookup formulas other than here
@ShimInsights1814
@ShimInsights1814 2 жыл бұрын
So impressing and helpful video. Thank you so much!
@ramsrikar1876
@ramsrikar1876 Жыл бұрын
Helped a lot. How to find which student got least value if we do not know neither
@testing-mv2vu
@testing-mv2vu 2 жыл бұрын
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.
@kingbenson6305
@kingbenson6305 2 жыл бұрын
Thank you for help brother, you explain them very well, God bless you.
@nashrollahbinsiddique5332
@nashrollahbinsiddique5332 2 жыл бұрын
superb teaching,Thank you so much sir,love from Bangladesh
@Renuka2024
@Renuka2024 3 жыл бұрын
I like the way you have explained.. it is easily understandable
@radish550
@radish550 4 жыл бұрын
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.
@lakshmikannan510
@lakshmikannan510 3 жыл бұрын
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.....
@harshaliyanage01
@harshaliyanage01 2 жыл бұрын
Super clear explanation 💚 thanks from sri lanka
@heezukaa8803
@heezukaa8803 Жыл бұрын
Great video sir very thankfull now i know the Vloopup functions are very powerfull 😊
@vincehewson2665
@vincehewson2665 2 жыл бұрын
Thank you for putting this video out and communicating the use case and lesson so well
@Urs_telugu_rowdy
@Urs_telugu_rowdy 3 жыл бұрын
It's really very useful vedio to learning excel people, thank you very much sir
@ArunKumarallplus
@ArunKumarallplus 5 жыл бұрын
thank you sir............. you really make others to understand the subject....
@anasahmed4400
@anasahmed4400 4 жыл бұрын
Hi thanks for the video. I can’t lock the cell with f4 please comment
@Asator66
@Asator66 Жыл бұрын
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
@malvikavaidya1164
@malvikavaidya1164 3 жыл бұрын
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?
@9072176376
@9072176376 3 жыл бұрын
Thanks a lot for the Valuable tutorial section.
@Energetic_Eswar
@Energetic_Eswar 4 жыл бұрын
If the required values in different columns(like in T, W, Z columns) rather than in side by side columns, what is the syntax.??
@shferaw4471
@shferaw4471 2 жыл бұрын
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?
@GuruJii
@GuruJii 2 жыл бұрын
we will get back to you Thank you. To see our latest videos please visit www.myelesson.org/
@rajkumarprajapti6821
@rajkumarprajapti6821 3 жыл бұрын
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
@vidassify
@vidassify 4 жыл бұрын
Thank you sir, the way you teach reminded me of my math teacher in school.
@macoylara3031
@macoylara3031 5 ай бұрын
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.
@manuvideos6143
@manuvideos6143 3 жыл бұрын
Thank you for this video and the way you r teaching is awesome
@samarthnaveen7659
@samarthnaveen7659 3 жыл бұрын
awsm video with great vlook up knowldege. but what if in class there are 2 jim and 3 Micky? Please help
@62-anikamubasshira54
@62-anikamubasshira54 3 жыл бұрын
thank you sir for explaining vlookup function on such a great way.. Now all my doubts are gone
@ramuammu3587
@ramuammu3587 4 жыл бұрын
Excellent speech i learnt alot from u which is usefull to my future thanq so much
@GuruJii
@GuruJii 4 жыл бұрын
Thanks
@ankarajumamidala9270
@ankarajumamidala9270 2 жыл бұрын
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?
@Anikvikram
@Anikvikram 4 жыл бұрын
Superb,simply superb.Sir can u plz upload a video on using vlookup in Google Sheets as well.
@awantikaparmar9037
@awantikaparmar9037 3 жыл бұрын
Thank you very much for the information.your sessions really helped me alot.
@AsifKhan-tf4er
@AsifKhan-tf4er 4 жыл бұрын
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..
@santhosh-pf9ls
@santhosh-pf9ls 2 жыл бұрын
hi sir, thanks for the lesson, but practice file is missing, if its their it will be more help full to practice
@ksadeesh54012
@ksadeesh54012 2 жыл бұрын
Superb great teaching skills thank you for the video
@raviprakashbatham9930
@raviprakashbatham9930 3 жыл бұрын
Thank you for this video Guru.☺️☺️👍👌
@narinderkumar9375
@narinderkumar9375 3 жыл бұрын
Sir agar array have some other words also. Will vlookup work?
@sharifulhaque6809
@sharifulhaque6809 4 жыл бұрын
Most effective and easiest way of teaching 👌
@BIR6764
@BIR6764 4 жыл бұрын
Guruji, Before my comment, you had already century. I just want to add pretty much similar to others, you taught fantastic. Thanks.
@republicofgamers4971
@republicofgamers4971 3 жыл бұрын
Thank you very much sir, it's help me a lot to improve my excel advance way.
@pushparaj3240
@pushparaj3240 4 жыл бұрын
Super master the video was very very informative and brilent thank you very much Brother keep upload the videos
@420Mrbabu
@420Mrbabu 3 жыл бұрын
I can really very useful video to me.... Thank you so much sir🤝
Vlookup Duplicate Repeated Values  in Excel in Hindi
8:59
My E-Lesson
Рет қаралды 238 М.
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
人是不能做到吗?#火影忍者 #家人  #佐助
00:20
火影忍者一家
Рет қаралды 20 МЛН
Advanced Excel - VLOOKUP Basics
11:58
Technology for Teachers and Students
Рет қаралды 2,2 МЛН
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 343 М.
5 Excel Questions Asked in Job Interviews ☑️
11:00
My E-Lesson
Рет қаралды 3,3 МЛН
How to VLookup in Differrent Workbook
4:34
Syed Shah Zahurullah Hussaini
Рет қаралды 232 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 8 МЛН
Excel Pivot Tables from scratch to an expert for half an hour + dashboard!
34:55
Билял Хасенов – Excel, VBA & More
Рет қаралды 2,2 МЛН
Excel Vlookup Tutorial - Everything You Need To Know
21:50
Excel Campus - Jon
Рет қаралды 2,6 МЛН
Excel VLOOKUP With Multiple Workbooks
12:14
Maxwell Stringham
Рет қаралды 3,5 МЛН
Vlookup Function in Excel for Beginners
11:35
Teacher's Tech
Рет қаралды 1,8 МЛН
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН