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

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

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

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

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

[@noboboro6782]

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

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

[@osmannafaah7635]

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

[@shankrukulkarni3234]

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

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

[@Caersy]

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

[@mohangaikwad7263]

Amazing👍 vlookup multiple values just saved my day!

[@yogitakhandagale5533]

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

[@sharifulhaque6809]

Most effective and easiest way of teaching 👌

[@shingshyanlee1569]

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

[@t.koothaiyannayanar5448]

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

[@poornimadave4122]

See multiple value was really helpful. Thank you sir.

[@Clumsiverse]

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

[@vincehewson2665]

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

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

[@ArunKumarallplus]

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

[@awantikaparmar9037]

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

[@johnsingh2780]

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

[@abdulnabi6564]

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

[@derrickthedon91]

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

[@gulshadali4043]

LOVE YOUR WAY OF TEACHING

[@ambersabih1175]

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

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

[@frankyfernandes6283]

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

[@nirmaniamerasinghe508]

Made my day ! Thank you

[@cebelihlemasuku8989]

Great presenting style, easy to follow

[@ramdeepakvanam2159]

i want to tell u sir, trust me ur narration is very powerful n well understanding.

[@labadventurestechnologies1400]

Best tutorial I've seen. Thanks.

[@yanwang5788]

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

[@sunilp948]

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

[@alicerong6095]

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

[@JulioCesarContrerashabilsa]

Excelente..gracias.. From Chile..

[@ashishh1323]

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

[@deepakumar4204]

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

[@BIR6764]

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

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

[@ramk1969]

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

[@darlasivaprasad3629]

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

[@karunakarmiriyala4942]

Thanks, helped me a lot in multiple vlookups

[@gaurideshpande3089]

Thank you very much for such a nice explanation.

[@vikramjitmitra]

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

[@Renuka2024]

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

[@vinithageorge613]

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

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

[@stardomee]

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

[@natashasamuel9346]

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

[@entertainmenttv.89]

Simply Defined, Superb brother

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

[@radhikapallerla89]

Awesome explanation, helped me a lot

[@tafadzwamherekumombe2825]

The GURU has proved himself.

[@emebetkebedewakie4304]

Thank you, I clear my dout in multiple values🙏

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

[@harrietdomingo4132]

how i learned so much from this tutorial! keep posting informative vids in esp. excel.

[@GuruJii]

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

[@shdwctchr]

Great video!!! Thank you for creating this.

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

[@62-anikamubasshira54]

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

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

[@savithafernandes3932]

Thank you so much for the effective information

[@dimpalsarma2449]

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

[@moshetty]

You are a life-saver.

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

[@muralishankar9719]

This was an Excellent video to know Vlookup for any beginner..

[@kingbenson6305]

Thank you for help brother, you explain them very well, God bless you.

[@ShimInsights1814]

So impressing and helpful video. Thank you so much!

[@harshaliyanage01]

Super clear explanation 💚 thanks from sri lanka

[@naumanfakharr5856]

Excellent teaching way specially for beginner thanks

[@MdIlyasShaikh]

Excellent sir ji .Thanks a lot for this.

[@arshadhossain4682]

Thanks for the multiple task vlookup...

[@9072176376]

Thanks a lot for the Valuable tutorial section.

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

[@vasanthreddy4687]

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

[@raviprakashbatham9930]

Thank you for this video Guru.☺️☺️👍👌

[@chiranjitsamanta9953]

This lesson was just owesome.

[@mageshsvm3235]

Started my excel knowledge, thank u G

[@sanyamjain2627]

One of the best vlook video on internet.. all ways described very precisely.

[@GuruJii]

Glad you liked it!!

[@Urs_telugu_rowdy]

It's really very useful vedio to learning excel people, thank you very much sir

[@glitched_official5837]

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

[@nashrollahbinsiddique5332]

superb teaching,Thank you so much sir,love from Bangladesh

[@p.aravindakashanmenon5743]

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

[@GuruJii]

Welcome

[@mkgowda-gb9no]

thankyou so much for the video i was confused by all the video urs was easier to understand and it worked for me

[@mehuldhakan743]

Simply explained... Excellent..

[@salmnz]

This was the video i was looking for thank you

[@archanashelar4368]

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

[@robertblack3867]

Marvellous teacher!

[@sekkaali]

very good explanation. Thanks

[@dineshgupta6861]

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

[@ameydoragude947]

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

[@oshunyt]

Excellent tutorial !!!

[@hemaprathyushap8555]

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

[@emmygraceamana8859]

Thank you for this tutorial video, it is helpful to me.

[@pratikchavan5129]

very useful video sir thank you for solving my problem.

[@sukanyaacharya433]

Sir its very easy to learn ..thanks a lot