7 Ways to Use Vlookup in Excel

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

[@maryamiffahabdulhamid2293]

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]

Thanku bhai

[@RamaChandraChessAcademy]

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

[@simpleexcelexamples9619]

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!

[@neenareadsalot7563]

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. :)

[@darlenebradley5827]

I just started using Vlookup and I love the examples. They were very helpful....thank you!

[@xaviervenancious778]

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]

you can see it. kzbin.info/www/bejne/qIenmY2rfsmde5Y

[@tansrihambalimohdpuat385]

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

[@noboboro6782]

I really valued your videos, I have been searching for multiple vlookups function, now I have cleared it from your video. Thanks Bro.

[@shubhamshejwal3985]

Thank you so much for this version of simplified Vlookup functions ❤️❤️❤️

[@vidassify]

Thank you sir, the way you teach reminded me of my math teacher in school.

[@sumangaddu9963]

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]

Thank you. To see our latest videos please visit www.myelesson.org/

[@janinenabos3530]

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!

[@yogitakhandagale5533]

All my concepts cleared .very well explained sir. Thank you so much

[@emrullahtan8695]

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]

I wonder, why must it be the first two columns only -- why not STUDENT NAME and all the way to HISTORY?

[@Filmy_Munch]

thanks dear I tried your suggestion and it really works thanks a lot

[@Caersy]

You are a good trainer even here 2021 still find this so helpful. Thank you

[@t.koothaiyannayanar5448]

Thank you very much for your unblemished service. God bless you

[@leeshingshyan]

Best vlookup video ever!!!!! Thanks, extremely helpful and love the simplicity of your explanation too!

[@shahzadakitchen]

kzbin.info/www/bejne/qIenmY2rfsmde5Y watch this for excel tutorial

[@poornimadave4122]

See multiple value was really helpful. Thank you sir.

[@osmannafaah7635]

Nafaah Osman from Ghana. Orderly and systematic presentation, you are indeed a GURU for you have made my day

[@BIR6764]

Guruji, Before my comment, you had already century. I just want to add pretty much similar to others, you taught fantastic. Thanks.

[@DoA121]

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]

So u r accountant🤔

[@hehzeus1764]

Omg cutie pie 🥰

[@mohangaikwad7263]

Amazing👍 vlookup multiple values just saved my day!

[@vincehewson2665]

Thank you for putting this video out and communicating the use case and lesson so well

[@radish550]

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.

[@awantikaparmar9037]

Thank you very much for the information.your sessions really helped me alot.

[@Clumsiverse]

this was so helpful. thank you so much and be safe with your family.

[@vikramjitmitra]

Brother you have simplified VlookUp so well :) .. You are doing an awesome job and helping so many of us.

[@nirmaniamerasinghe508]

Made my day ! Thank you

[@usamaathar3144]

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.

[@ambersabih1175]

Its amazing and your videos are best and comprehensive easiest way to learn excel.

[@JulioCesarContrerashabilsa]

Excelente..gracias.. From Chile..

[@sharifulhaque6809]

Most effective and easiest way of teaching 👌

[@abdulnabi6564]

it was needed to me. Now I have learnt. Thank You so much.

[@cebelihlemasuku8989]

Great presenting style, easy to follow

[@ArunKumarallplus]

thank you sir............. you really make others to understand the subject....

[@johnsingh2780]

It will save my time a lot...especially multiple column part .....thanks a lot

[@62-anikamubasshira54]

thank you sir for explaining vlookup function on such a great way.. Now all my doubts are gone

[@gulshadali4043]

LOVE YOUR WAY OF TEACHING

[@derrickthedon91]

This is the best Vlookup tutorial... I have understand to a better extent... Really really nice teaching...

[@fanyang2365]

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]

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.

[@ramk1969]

Thank you,Guruji.. Very very useful ..Especially horizontal copy formula.

[@deepakumar4204]

Checked many vlook up videos, this is the most well explained

[@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 🙏

[@gaurideshpande3089]

Thank you very much for such a nice explanation.

[@darlasivaprasad3629]

This lesson Is very understandable...superb explanation sir...tq

[@rishijain9651]

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...

[@natashasamuel9346]

Great class. Keep up the good work. Thank You, Natasha Samuel

[@karunakarmiriyala4942]

Thanks, helped me a lot in multiple vlookups

[@ashishh1323]

This is probably the easiest explanation of vlookup I have ever come across till now.

[@arshadhossain4682]

Thanks for the multiple task vlookup...

[@savithafernandes3932]

Thank you so much for the effective information

[@shekreshma]

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

[@radhikapallerla89]

Awesome explanation, helped me a lot

[@shdwctchr]

Great video!!! Thank you for creating this.

[@moshetty]

You are a life-saver.

[@Renuka2024]

I like the way you have explained.. it is easily understandable

[@yanwang5788]

#5 is very important functions. THANK YOU SO MUCH!!!!!

[@entertainmenttv.89]

Simply Defined, Superb brother

[@stardomee]

the mention of absolute values using F4 solved my problem, thank you!

[@labadventurestechnologies1400]

Best tutorial I've seen. Thanks.

[@mdasifhassan]

Thank you so much.Learnt new points specially 5 th point

[@techworld2528]

this video is very useful for excel kzbin.info/www/bejne/parWm5d7as-FY8U

[@sunilp948]

This is really best way to learn Vlook up...Simple, and complete.. Really liked it.. Thanks

[@salmnz]

This was the video i was looking for thank you

[@sudlol]

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]

Thank you. To see our latest videos please visit www.myelesson.org/

[@alicerong6095]

Very simple and easy to understand. Indeed very helpful. Thank you

[@p.aravindakashanmenon5743]

"Vlookup multiple values at once". Very super. I cleared my doubts and learned. Thank you, Sir.

[@GuruJii]

Welcome

[@archanashelar4368]

Vlookup multiple values at once , well explained 😃...

[@glitched_official5837]

Thank you soo much sir, was really struggling with it .

[@syedpasha5683]

Awesome.... Sometime I get confused with that dollars symbols I guess it will come by practice.

[@MdIlyasShaikh]

Excellent sir ji .Thanks a lot for this.

[@shankrukulkarni3234]

Thank you... You saved my lots of time.. God bless you

[@frankyfernandes6283]

Just at 3:42 minutes and I am liking the way of explaining. It is like a friend sitting next and explaining. :)

[@dineshgupta6861]

Thank U Sir G...U R our Guru...

[@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]

Many thanks for this video. I had an interview and this has really helped me.

[@ameydoragude947]

Thank you 😊... This video is very useful.

[@farhankhan3994]

Hi, sir, If need to vlookup the value of an item from defernt sheet and the items values shows with twice time so how could we find. Plz advice

[@mageshsvm3235]

Started my excel knowledge, thank u G

[@prashantkiratkar.5747]

Thanks a lot for this wonderful explanation! Helped a lot! Thanks for the practice files too! I really appreciate it!

[@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 😊

[@infinitestories06]

Can't thank you enough for this Found no ease in learning lookup formulas other than here

[@aratidas6143]

It's very helpful, special v lookup multiple values at once

[@noorameera26]

Definite life-saver!!!

[@vasanthreddy4687]

Very nice teaching. It's so much helpful for who don't have any basics idea in vlookup 👍.

[@hemaprathyushap8555]

The video really helped me a lot.... Thankyou so much

[@chiranjitsamanta9953]

This lesson was just owesome.

[@ShimInsights1814]

So impressing and helpful video. Thank you so much!

[@PavanKumar-us8ru]

It's really nice n cool way. I just learnt 5th point thank you really.

[@techworld2528]

this video is very useful for excel kzbin.info/www/bejne/parWm5d7as-FY8U

[@mjmash007]

Luckily I peeked the 2nd intake practical test on my 1st interview intake and saw vlookup questions. I'm Hours away from the interview and studying this 😇🙏💯

[@dimpalsarma2449]

Ohh yes this is the video I hv been searching. Very helpful

[@alejandrodominguezrodrigue8431]

Thank you very much!

[@9072176376]

Thanks a lot for the Valuable tutorial section.

[@FitUp-vr3ym]

I never saw such an easy explanation of vlookup. Thank you sir ❤

[@sukanyaacharya433]

Sir its very easy to learn ..thanks a lot

[@emebetkebedewakie4304]

Thank you, I clear my dout in multiple values🙏

[@sekkaali]

very good explanation. Thanks

[@rvofficebookmarks7647]

Thank You for the video.. This is really helpful 👍

[@shamsundar7585]

Tq sir, teaching very well !

[@tafadzwamherekumombe2825]

The GURU has proved himself.

[@crownwang81]

Point 5,6 and 7 take my skill to a higher level, thank you Sir.