7 Ways to Use Vlookup in Excel
Вставка
- Опубліковано 6 гру 2018
- Learn Vlookup in Excel. I have explained 7 ways of using Vlookup in Excel so that you can learn this important formula of excel. Download file from www.myelesson.org
7 Ways to Use Vlookup in Excel are
1 Normal Vlookup
2 Vlookup From Different Sheet
3 Vlookup From Different Workbook
4 Copy Vlookup Formula
5 Vlookup Multiple Values At Once
6 Vlookup Smallest Value
7 Vlookup Largest Value
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.org/product or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy
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
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
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. :)
I just started using Vlookup and I love the examples. They were very helpful....thank you!
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. ua-cam.com/video/rVDhZuIdjE4/v-deo.html
I really valued your videos, I have been searching for multiple vlookups function, now I have cleared it from your video. Thanks Bro.
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/
Thanks for this video! I already was familiar with the VLOOKUP function but i learned a lot seeing the use of the function in this depth!
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
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!
Nafaah Osman from Ghana. Orderly and systematic presentation, you are indeed a GURU for you have made my day
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 🥰
Amazing👍 vlookup multiple values just saved my day!
You are a good trainer even here 2021 still find this so helpful.
Thank you
Thank you so much for this version of simplified Vlookup functions ❤️❤️❤️
Best vlookup video ever!!!!! Thanks, extremely helpful and love the simplicity of your explanation too!
ua-cam.com/video/rVDhZuIdjE4/v-deo.html watch this for excel tutorial
All my concepts cleared .very well explained sir. Thank you so much
Thank you sir, the way you teach reminded me of my math teacher in school.
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.
This is probably the easiest explanation of vlookup I have ever come across till now.
Made my day ! Thank you
Most effective and easiest way of teaching 👌
Brother you have simplified VlookUp so well :) .. You are doing an awesome job and helping so many of us.
Thank you very much for your unblemished service.
God bless you
this was so helpful. thank you so much and be safe with your family.
it was needed to me. Now I have learnt. Thank You so much.
See multiple value was really helpful. Thank you sir.
Thank you very much for the information.your sessions really helped me alot.
Thank you for putting this video out and communicating the use case and lesson so well
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 🙏
This is the best Vlookup tutorial...
I have understand to a better extent...
Really really nice teaching...
I never saw such an easy explanation of vlookup. Thank you sir ❤
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/
Just at 3:42 minutes and I am liking the way of explaining. It is like a friend sitting next and explaining. :)
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
Guruji,
Before my comment, you had already century. I just want to add pretty much similar to others, you taught fantastic. Thanks.
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
It will save my time a lot...especially multiple column part .....thanks a lot
Its amazing and your videos are best and comprehensive easiest way to learn excel.
LOVE YOUR WAY OF TEACHING
Excelente..gracias.. From Chile..
Great Video. I have seen 10 more videos but at the end I was able to perform my assignment after watching this video only.
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
Best tutorial I've seen. Thanks.
This is really best way to learn Vlook up...Simple, and complete.. Really liked it.. Thanks
thank you sir............. you really make others to understand the subject....
The GURU has proved himself.
Ohh yes this is the video I hv been searching. Very helpful
Many thanks for this video. I had an interview and this has really helped me.
Checked many vlook up videos, this is the most well explained
This was the video i was looking for thank you
#5 is very important functions. THANK YOU SO MUCH!!!!!
Definite life-saver!!!
Great presenting style, easy to follow
You are a life-saver.
Great video!!! Thank you for creating this.
Thank you,Guruji.. Very very useful ..Especially horizontal copy formula.
Very simple and easy to understand.
Indeed very helpful.
Thank you
This lesson Is very understandable...superb explanation sir...tq
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 😊
the mention of absolute values using F4 solved my problem, thank you!
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/
thank you sir for explaining vlookup function on such a great way.. Now all my doubts are gone
One of the best vlook video on internet.. all ways described very precisely.
Glad you liked it!!
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
Awesome explanation, helped me a lot
I like the way you have explained.. it is easily understandable
Simply Defined, Superb brother
Can't thank you enough for this
Found no ease in learning lookup formulas other than here
Thank you very much for such a nice explanation.
Marvellous teacher!
Thanks, helped me a lot in multiple vlookups
Thank U Sir G...U R our Guru...
This lesson was just owesome.
Excellent sir ji .Thanks a lot for this.
This was an Excellent video to know Vlookup for any beginner..
Very nice teaching. It's so much helpful for who don't have any basics idea in vlookup 👍.
So impressing and helpful video. Thank you so much!
Thanks a lot for this wonderful explanation! Helped a lot! Thanks for the practice files too! I really appreciate it!
Thanks a lot for the Valuable tutorial section.
Started my excel knowledge, thank u G
Thank you 😊... This video is very useful.
superb teaching,Thank you so much sir,love from Bangladesh
Thank you so much for the effective information
Super clear explanation 💚 thanks from sri lanka
Point 5,6 and 7 take my skill to a higher level, thank you Sir.
Thanks for the multiple task vlookup...
Vlookup multiple values at once , well explained 😃...
thankyou so much for the video i was confused by all the video urs was easier to understand and it worked for me
Thank you soo much sir, was really struggling with it .
It's really very useful vedio to learning excel people, thank you very much sir
God Bless You My Brother
Sir its very easy to learn ..thanks a lot
hi
please tell me ifi have made the duty rota sheet for the employees of the company and I have to apply vlookup to see the shift timings or weekly off from monday to sunday...
The video really helped me a lot....
Thankyou so much
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.
Thank you for help brother, you explain them very well, God bless you.
amazing!!!! thank you sir!!!
Excellent teaching way specially for beginner thanks