HomeОбразованиеRelated VideosMore From: ExcelIsFun

Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)

841 ratings | 25618 views
Need to learn all about VLOOKUP? Microsoft Excel MVP & Highline College Professor, Mike “excelisfun” Girvin, presents 15 amazing VLOOKUP examples, from the basics to advanced. Download Excel START File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/StartFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx Download Source file: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/SourceData.xlsx Download Excel FINISHED File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/FinishedFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx In this video Learn all about VLOOKUP. Learn from Basics to Advanced. See 12 amazing examples that will help you become a VLLOKUP Excel Master! Video taught by Microsoft Excel MVP and Excel YouTuber, Mike Girvin. Topics: (00:06) Introduction 1. (01:32) VLOOKUP is everywhere (04:24) The different between Exact Match & Approximate Match Lookup 2. (06:00) VLOOKUP to Lookup Product Price (Exact Match Lookup) 3. (12:25) VLOOKUP to Lookup Straight Commission Rate (Approximate Match Lookup) 4. (18:32) Data Validation List & VLOOKUP 5. (21:45) Copy VLOOKUP Down a Column. Learn about Relative and Absolute Cell References. 6. (27:00) Dynamic Lookup Table: Excel Table feature 7. (31:47) Dynamic Data Source: Use Power Query to import Lookup Table 8. (36:14) VLOOKUP to Lookup Variable Commission Rate (Approximate Match Lookup) 9. (41:00) VLOOKUP & MATCH Function for Two-Way Lookup (Lookup Employee Information) 10. (48:02) Fuzzy Lookup = Incomplete Lookup Value 11. (51:50) VLOOKUP & IFNA Functions to Avoid Errors 12. (53:05) Partial Text Lookup & Converting Text Number to Number 13. (56:28) Avoid Zeros from VLOOKUP to Empty Cells 14. (58:27) Multiple Table Lookup with VLOOKUP and INDIRECT Functions 15. (01:04:40) Two Lookup Values (01:08:29)Summary
Html code for embedding videos on your blog
Text Comments (172)
I love the way you show mistakes, and explain everything in bite sized pieces; every little detail and then repeat it a couple of times, so much easier to grasp and memorize.
Dillip Senapati (26 days ago)
Excellent tutorial for beginners. I am following.
ExcelIsFun (26 days ago)
I am glad that the videos help, Dillip!!! Thanks for your support with your comment, Thumbs Up and Sub : )
mahesh nayak (1 month ago)
you are just amazing!!
ExcelIsFun (1 month ago)
Glad you like the video, mahesh!!! Thank you for the support with your comment, Thumbs Up and Sub : )
syed ibrahim (1 month ago)
You are EXCEL SUPER MAN.....
makulu1 (1 month ago)
I went here just because I was curious about the magic but watching this you solved 4 problems I was having and didn't know a solution even existed. Thank you!!!!
Geovanny Tineo (1 month ago)
Jesus christ, 8 pieces of shit disliked this video. I dont know why though! This was amazing.
elhassan simlaoui (1 month ago)
very well done. Mike you did it again your videos are so so valuables and clear. thank you for your sharing.
ExcelIsFun (1 month ago)
I am glad that the videos are of value to you and that they are clear!!! Thanks for your support, elhassan simlaoui, with your comment, Thumbs Up and Sub : )
Laxmiprasad DB (1 month ago)
Thanks 🙏
ExcelIsFun (1 month ago)
You are welcome, Laxmiprasad D!!! Thank you for the support with your comment, Thumbs Up and Sub : )
knowlege book (1 month ago)
Great great great you are awesome ....👌👌👌👌👌👌👌👌👌👌👌👌👌
ExcelIsFun (1 month ago)
Thank you for the many, many Okay hand symbols : ) : )
MF Wong (1 month ago)
Like the simple trick to avoid zero at 56:28. I've shared it via my blog. :) https://wmfexcel.com/2018/10/17/learn-something-new-from-something-that-i-think-i-knew-well/
ExcelIsFun (1 month ago)
Glad that the tricks help, MF Wong!!! Thanks for the share : )
mahesh .n (1 month ago)
Sir please make a video on how to connect same excel sheet which are in different folders. If we update the data in one excel sheet it has to come in the same sheet which is in the different folder. Sir I am very thank ful to you if you make video on this
ExcelIsFun (1 month ago)
Here is a video that shows how to make a Workbook Reference: https://www.youtube.com/watch?v=51JdnRuR4VY Click in the "Show More" button below this video to see Table of Contents, then you will see the section on Workbook References. The line in the Table of Contents looks like this: 14. (01:00:22) Example 14: Workbook Reference. Goal: Access Net Income Number from External Workbook.
mahesh .n (1 month ago)
Excellent explanation thank you very much
ExcelIsFun (1 month ago)
You are welcome for the EXCELlent video!!!! Thank you, mahesh .n, for your support with your comment, Thumbs Up and Subscription : )
George Muirhead (1 month ago)
Thanks Mike your a superb teacher!
ExcelIsFun (1 month ago)
You are welcome, George! Thanks for the kind words! And thanks for your support : )
mostafa4321 (1 month ago)
Excellent presentation Thank yu :)
ExcelIsFun (1 month ago)
I am glad it is EXCELlent for you, mostafa4321!!!! Thank you for the support with your Comments, Thumbs Ups and Sub : )
Graham Waters (2 months ago)
The Excel START sheet needs to be cleaned up, it has an error in the name formula in cell A1 and has completed work in topic 6.
ExcelIsFun (2 months ago)
Thanks for letting me know. I changed the sheet (6) so it did not have the completed work, but the Name error is because the file uses an Office 365 function, TEXTJOIN, that may not be in your version.
Amit Bhartia (2 months ago)
Truly brilliant, the vlookup match function just helped me reduce a heavy nested if statement to a much concise formula
ExcelIsFun (2 months ago)
I love to hear that a trick in this video helps you to become more efficient! Thanks for your support, Amit, with your comment, Thumbs Up and Sub : )
sachin jain (2 months ago)
Hey! The way you taught us v lookup..i think this is the best ever learn video available on YouTube for learning you v lookup... I will recommend this video whosoever wants to learn the correct applicability of v look up. Once again thnks for making effortless video.
ExcelIsFun (2 months ago)
You are welcome, sachin! Thank you very much for your support with your comment, Thumbs Up and telling your friends : )
Abdallah Ally (2 months ago)
Thank you Mike. Can you do an INDEX and MATCH tut using office 2016? Again thanks
ExcelIsFun (2 months ago)
I have over 100 videos on that topic already : ) Here is a great one for you: https://www.youtube.com/watch?v=u-8D2G0y9EM Thanks for your support with your comments and Thumbs Up on each video that you watch : )
A S (2 months ago)
Hi, looking for your help, can i have ur whatsapp or email? Thanks.
Adrian Paul Layug (2 months ago)
OMG! I learned more a lot in your videos than attending my computer classes! Good job. Continue helping students. Thanks a lot
ExcelIsFun (2 months ago)
I am glad that the video helped you to learn, Adrian!!!! Thanks for the support with your comment, Thumbs Up and Sub : )
Leong Peng Kong (2 months ago)
I have viewed many YouTube instructional clips. You are by far the BEST. Precise, to the point, no deviation away from the subject matter and ahhhhs and emmmms. You have designed a step by step instruction by smart usage of the worksheets. Yes. You are right. I have been using long “If” argument when Vlookup can do the job. Thank you. Great job.
ExcelIsFun (2 months ago)
Yes, you and I and many others use the long IF and then we learn VLOOKUP - and Bam! our lives become much more fun!!!! Thank you for your kind words, Leong Peng Kong, and thank you for your support with your comment, Thumbs Up and Sub : )
Abdulrahman Joseph Sesay (2 months ago)
After following most of your videos, I can at least say that I'm Understanding Excel in this part of the World. Thank you Mr. Excel.
ExcelIsFun (2 months ago)
You are welcome!!! But I am not Mr Excel. That is a different YouTuber called Bill "Mr Excel" Jelen. I am excelisfun : )
Abdulrahman Joseph Sesay (2 months ago)
Mr. Mike, you are very good. Please know that you have a very curious student in Sierra Leone.
ExcelIsFun (2 months ago)
I am very glad that you are curious and have come to watch these videos, Abdulrahman!!! I hope the videos fulfill your curiosity! Thanks you for the support with your comment, Thumbs Up and Sub!
Veronica Busuioc (2 months ago)
I put like before watching ! I know these videos are amazing ! Thanks!
ExcelIsFun (2 months ago)
Thank you, Veronica!!!! Thanks for your support : )
AJ Thompson (2 months ago)
Thanks for another great video on this very useful VLOOKUP function. So many cool examples showing what is possible with this powerful tool. My personal favorite was #14 with all those pipe price tables coming together like a well-plumbed charm. All of the different examples are superb, surely very helpful for people in all sorts of fields. Also, thank you for the time-stamps and helpful files that we can practice and learn with. :)
ExcelIsFun (2 months ago)
You are welcome for the video and time hyper links and files, AJ!!!! Thank you for your support of the excelisfun channel here at YouTube : )
Rob Michaels (2 months ago)
Perhaps my formula does not belong in a VLOOKUP video but I always like to use the INDEX-MATCH combination so I don't have to worry about the VLOOKUP column being on the left. Here is the formula I have in example (9) cell B27 =INDEX($A$8:$G$17,MATCH($A$27,$A$8:$A$17,0),MATCH(B26,$A$7:$G$7,0)). Thanks again for the VLOOKUP video. I always learn new things from your videos!
ExcelIsFun (2 months ago)
Yes, INDEX can do almost everything that VLOOKUP can do, but it is still so widely used and has no real performance differences as compared to INDEX and MATCH, and job interviews like to ask about it, I must still teach it, and in fact, I prefer VLOOKUP and MATCH for math two way lookups because for me, it is easier to type the formula out and it only uses two functions. Thanks for your support, Rob!!!
Sachin Vartak (2 months ago)
Hi, Thanks for uploading an exhaustive video on age old and most popular VLOOKUP. Not many still know how versatile VLOOKUP can be when used with other functions. Also the approximate match feature of this function is something really amazing in specific situations. Thanks again :)
ExcelIsFun (2 months ago)
You are welcome!!! I agree: VLOOKUP has been around for a long time and it is still useful today : )
NoShadowOfDoubt (2 months ago)
I tend to use fuzzy lookups sometimes to conform to the fuzzy ways some of my co-workers fill their spreadsheets .....
DENNIS ANTWI (2 months ago)
Great video
amit kumar (2 months ago)
Mike, take a bow!
ExcelIsFun (2 months ago)
Thanks for your support, amit kumar!!!!
ExcelIsFun (2 months ago)
I can't do that because it would take time away from making more videos ; )
John Borg (2 months ago)
Always learning. Vlookup(.........)&"" to show a null text string instead of a zero. I never knew that!!! Thanks Mike. :)
John Borg (2 months ago)
Well, that's your channel Mike, for whoever wants to join :) :)
ExcelIsFun (2 months ago)
I love it! There should be a YouTube Channel named excelallthetime : )
John Borg (2 months ago)
Excel all the time :)
ExcelIsFun (2 months ago)
What did you talk about?
John Borg (2 months ago)
Yes ofcourse and lots of others like Pete_SSs who is one of the moderators of Mr Excel Message board, who came over to Malta and guess what we talked about?? :)
giovani franco (2 months ago)
Thanks to your lessons and your precise instructions, I won first place in one of the most popular Excel / VBA forums in Brazil. Thank you, master for your instructions. Your acknowledgment I posted on my timeline at: https://www.facebook.com/giovani.franco.9
ExcelIsFun (2 months ago)
Wow!!!! That is so amazing : ) You are welcome for the instruction! Congratulations on winning first place in the Excel competition!
Wayne Seymour (2 months ago)
Hi Mike, I have a very strange problem I have been trying to resolve for a couple days now. I'm using a code I discovered on line that is suppose to allow me to filter and edit data from a list box and save it back ro my excel sheet. the only problem is that it will update the data I selected to edit and place it back to the work sheet ,the only problem is that it deletes the filtered data and I can no longer get that record back. Hope I'm making sense.
ExcelIsFun (2 months ago)
Thanks for watching and thanks for the support with your comments, Thumbs Up and Sub : ) The support helps keep things going. Do check out mrexcel.com/forum for help with VBA code.
Wayne Seymour (2 months ago)
ExcelIsFun  I watch all the time
ExcelIsFun (2 months ago)
BTW, did you enjoy this video, or are you just asking questions?
ExcelIsFun (2 months ago)
I am not good with VBA code - so I cannot help on this issue : ( But: Try this great Excel question site: mrexcel.com/forum
Bheemappa N. Bellad (2 months ago)
Dear sir, I am your big fan sir. I am working as science teacher. I learnt so many things in excel by your tutorials. Thank you so much sir. I have one problem sir. Plz suggest me a solution. Problem: how to add numbers inside and outside the bracket in excel sheet? (i am facing this problem while preparing blue print of 10th std science question paper for students). Ex: 1(1)+2(2)+3(1)+4(2)=16(6) Meaning of this: 1mark 1 question +2 mark 2 questions + 3 mark 1 question + 4 mark 2 questions=16 marks 6 questions.
excel is fun (2 months ago)
I do not know how to do that. You can try posting your question here: mrexcel.com/forum
Bheemappa N. Bellad (2 months ago)
+ExcelIsFun I am very grateful if you make a small excel video about solution to my problem as i mentioned earlier. Thank you very much for your kind reply sir.
Bheemappa N. Bellad (2 months ago)
+ExcelIsFun yes sir you are right. But i want answer in the format as 16(6). Means plz suggest me a formula to add numbers both outside and inside the bracket separately. Ex: cell A1 contains 1(1) cell B1 contains 2(2) cell C1 contains 3(1) cell D1 contains 4(2) Answer that i need in cell E1 should be in the format of 16(6)
ExcelIsFun (2 months ago)
Thanks for your support on each video that you watch with your comments, Thumbs Up and Sub : )
ExcelIsFun (2 months ago)
If I understand your question, then maybe this: =1*1+2*2+3*1+4*2 = 16
Ilya G (2 months ago)
Perfectly explained!
Ilya G (2 months ago)
I am BIG Fan! My name is Ilya Gordeev.
ExcelIsFun (2 months ago)
Glad it was good for you, Ilya G!!! Thanks for the support with your comment, Sub and Thumbs Up : )
Ranjeet Verma (2 months ago)
I have seen your vlookup formula video and I want you to more explain your vlookup formula with mid condition.
Ranjeet Verma (2 months ago)
This video didn't help me because I have seen this earlier.
ExcelIsFun (2 months ago)
Here is a video I made about VLOOKUP and MID: Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble https://www.youtube.com/watch?v=ct_IGgpYpMI
Ranjeet Verma (2 months ago)
Hello sir I have a problem in Excel could you please help me. In solving this problem.
Ranjeet Verma (2 months ago)
Sir my question is I have 9 digits MICR Code I want it to break into this in some parts. Like I have breaked it down in left 6 using left function and breaked it down in 3 digits using mid function and took left 6 and mid in vlookup formula all was ok but I want it to break down furthermore. Like this =vlookup (concatenate (left(a2,1),mid(a2,4,3)), table aray, 1,0) Is this possible. Please do this for it will help me. In solving some of the things. Because I am not getting any answers by using this. I want 1st digit and middle 3 digits fixed and all remaining digits should be variable.
Ranjeet Verma (2 months ago)
Sir I am a great fan your videos because it has some great Excel tricks which I cannot find from anywhere. And thanks for reply.
Ranjeet Verma (2 months ago)
Sir it really great video for me and found this more helpful.
ExcelIsFun (2 months ago)
This is more just a site for posting videos about Excel. THE best Excel question site for back and forth dialog to get Excel solutions is: mrexcel.com/forum
ExcelIsFun (2 months ago)
Did you like this video? Was it helpful to you?
HABIBUL AHMAD (2 months ago)
Excellent video
ExcelIsFun (2 months ago)
Glad it was EXCELlent for you, HABIBUL!!!! Thanks for the support with your comment, Thumbs Up and Sub : )
TMark Group LLC (2 months ago)
Just found your channel and amazed by your content! How can I contact you by email regarding some specific financial workbooks? Thanks!
ExcelIsFun (2 months ago)
Which video are you trying to find a workbook for?
TMark Group LLC (2 months ago)
ExcelIsFun I was just looking for some guidance in locating some specific workbooks you have posted!
ExcelIsFun (2 months ago)
I am not able to do consulting at this time. Try this amazing Excel web site for both paid help and a great "free" question site: mrexcel.com
Felipe Castro (2 months ago)
Thanks a lot !!!!! the video has a lot of details and the explanation goes deeply and steps by step, Muchas gracias!!!
ExcelIsFun (2 months ago)
You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )
Yen# d'life (2 months ago)
Hi Mike, I just tried to looking for your video about how to creat a searchable drop down list. Much appreciated if I can get a video link. Your tutorial video is much easier for me to learn the powerful of Microsoft excel.
ExcelIsFun (2 months ago)
I do not have a video on searchable drop-downs. There might be a way with VBA or some other method. Try posting your question to this amazing Excel question site: mrexcel.com/forum
Maneshkumar Zaveri (2 months ago)
Great refresher course ....as always easy to understand your explanations. Had forgotten about wild card, thanks for reminding. Thanks Mike
ExcelIsFun (2 months ago)
You are welcome for the VLOOKUP refresher course, Maneshkumar!!!!! Thanks for your continued support : )
Michael Taylor (2 months ago)
If there is a VLOOKUP God, it'd be Mike. ✔️
ExcelIsFun (2 months ago)
Just a guy having fun with Excel : )
3yebex (2 months ago)
SourceData.xlsx is NOT down below for users to download.
ExcelIsFun (2 months ago)
I am sorry about that. I just posted it - so it should be working now.
Kevin Lynn (2 months ago)
Ironically I think the dislikes, also promote the video... possibly
ExcelIsFun (2 months ago)
Thanks for the encouragement, Kevin Lynn : ) And thankis for your support!
Abdullah Ismail (2 months ago)
hi mike what is your Microsoft office version 2013 or 2016 ?
ExcelIsFun (2 months ago)
The version is Office 365. It is NOT Excel 2016 or 2013.
Mohamed Chakroun (2 months ago)
Amazing like always Master...No comment ... Thumbs up :-) and thumbs down for whom putting thumbs down
ExcelIsFun (2 months ago)
Thanks for your kind words! And thanks for your support, Mohamed Chakroun!
Fuad Khan (2 months ago)
You are the best sir.
ExcelIsFun (2 months ago)
Glad you like the video, Fuad Khan!!! Thank you very much for the support with your comment, Thumbs Ups and Sub : )
Wayne Edmondson (2 months ago)
Hi Mike.. an excellent and comprehensive tutorial on VLOOKUP and various creative techniques to use it effectively to do work. Since I have spend time with your Busn 216 and Busn 218 video series, I found it all very clear and understandable. I can't tell you how fortunate we are as a community to have you sharing your knowledge and teaching us all how to be better at EXCEL and at our jobs. You are the master. Thanks for your generosity and your continued support and contribution to the community of students, professionals and peers who benefit from your excellent videos and also the sample files that make it so easy to follow along and practice the concepts during the tutorial. Thumbs up!
ExcelIsFun (2 months ago)
You are welcome, Wayne!!! I am happy to provide resources for the last ten years for all that want to learn : ) Thank you for your support!
This is so awesome. Thanks Mike for this EXCELlent video.
ExcelIsFun (2 months ago)
You are welcome, Syed!!! Thank you for your amazingly consistent support : )
Malina C. (2 months ago)
VLOOKUP fun! Thanks, Mike!
ExcelIsFun (2 months ago)
You are welcome, Teammate Malina!!!! VLOOKUP is fun : )
M. SZ. (2 months ago)
Thank you, Mike. This one reminds me of your VLOOKUP Shark Week video that I enjoyed during the summer. And, of course, there is VLOOKUP in every Excel full series. An important subject matter.
ExcelIsFun (2 months ago)
Yes, this is an updated and more carefully edited version of that older video from back in early 2012!!!! Yes, even though we have new tools like Relationships, Data Models, Power Pivot and Power BI Desktop, VLOOKUP is still one of the most important topics because there are hundreds of uses where we need it for calculating and other Excel spreadsheet solutions. Plus, it is still one of the key questions asked in job interviews. Thank you very much, M. SZ. for your support of the excelisfun channel here at YouTube : )
Rajesh Jawajala (2 months ago)
One of the best & most comprehensive explanations about the versatility of the Vlookup functions with its use & applicability in a wide variety of situations & ways. Thanks a lot for the efforts taken , God Bless
ExcelIsFun (2 months ago)
You are welcome a lot for the VLOOKUP efforts! Thanks for your support, Rajesh Jawajala!!!!!
Haider Ali (2 months ago)
u got amazing teaching skills...... God Bless You... Thanks for sharing
ExcelIsFun (2 months ago)
You are welcome! I will continue to work hard, have fun and try to make the world a better place : )
Haider Ali (2 months ago)
for me you are one of the best teacher i have.. I love the way you teach with great passion , determination, hardwork.... God bless you and keep inspiring us.....
ExcelIsFun (2 months ago)
Yes, I have worked hard for 20 years trying to get better each day with teaching Excel - each day I try and tell the story just a bit better so that an advanced topic can be understood by even more people. It is as if I have drilled down from the top group of advanced thinks to us normal people (like me - because I am not too smart), try each day to change the story that I teach so that each day more and more of us regular people can try and understand complex topics. It is funny, in almost all advanced Text Academic Textbooks they teach VLOOKUP and PivotTables as advanced topics. But they are not. If you tell the right story, they are very easy to understand. The sad thing for me is that when I created the Excel Basics series (which I think that you have watched), I asked Microsoft to help promote it (because there is no other free resource in the world that teaches the complete Excel Story in an easy to understand way), but they will not. It has been almost a year of me asking them to help me to promote it, but they have not. Thank you, Haider, for awarding me the Noble Price in Excel : )
Haider Ali (2 months ago)
+ExcelIsFun the way you explain and teach things are exceptional.. i think for a layman can even learn excel from your videos. u deserve a noble prize for your achievement in Excel world...
ExcelIsFun (2 months ago)
Glad you like the teaching! I tried to put it all together so that we could have a One-Stop-Shopping VLOOKUP video : ) Thanks for your support, Haider Ali, with comments and Thumbs Up : )
VINAY KUMAR (2 months ago)
U are the master in excel, i have learnt a lot through ur vdo, now i am going to training in my org..thanks a ton!
ExcelIsFun (2 months ago)
You are welcome! That is great that you can take what you learn and "play it forward" and teach others! Thanks for your support with your comment, Thumbs Up, Sub and by telling all your friends : )
Sam Finance Tech (2 months ago)
Love these tips 💎💎
ExcelIsFun (2 months ago)
Glad you love the diamond tips, Sam Finance Concepts : ) Thank you for your support : )
Ankit Kulshrestha (2 months ago)
I throught I was the champ of Vlookup but looks like I am missing so many things here... Thanks mate
ExcelIsFun (2 months ago)
That is why I post these epic videos - so there is something useful and fun for everyone, even VLOOKUP masters like you!!Thanks for your support, Ankit, with your comment, Thumbs Up and Sub : )
Mohamed Raslan (2 months ago)
you are amazing
ExcelIsFun (2 months ago)
Glad the video was amazing, Mohamed! Thanks for your support : )
clifford (2 months ago)
Thanks Gel!
ExcelIsFun (2 months ago)
You are welcome! Lots of fun Gel Boom examples in this video : ) Thanks for your support !!!!
afzongho (2 months ago)
You Da Real MVP !
ExcelIsFun (2 months ago)
Glad you like the video, afzongho!!!! Thanks for the support : )
Imad Babbili (2 months ago)
Unbelievably professional
LORETTA MAK (2 months ago)
Thank you so much for sharing. May I ask where can I download the SourceData.xlsx file?
ExcelIsFun (2 months ago)
Wow! I am so sorry. I forgot to post it : ( I will not be back at work until Monday. I will post it them. In the meantime you can make a file and try it that way.
elhassan simlaoui (2 months ago)
Nice video as usual. and yes you did it : 500k subscribers very well done and well deserved. thank you.
ExcelIsFun (2 months ago)
You are welcome for the video : ) Thank you for kind words, elhassan!!!!
Tulsidas Jamnani (2 months ago)
Congratulations..... For 500k subscribers...
ExcelIsFun (2 months ago)
Thanks for the Congratulations, Tulsidas, and thanks for your support : )
Leila Gharani (2 months ago)
Congratulations on 500k! This week is VLOOKUP week :) Love the detailed explanation and variations!
ExcelIsFun (2 months ago)
VLOOKUP Week: I love that!!! Thanks for the congrats, Teammate : )
5%LowBattery (2 months ago)
I’m always confused when I come to these videos and see dislike. Like Who does that?
ExcelIsFun (2 months ago)
Thanks for the kind words, 5%LowBattery! You are awesome : )
Chris Mancinelli (2 months ago)
Great examples Mike, very useful!!
ExcelIsFun (2 months ago)
It is a LOT about VLOOKUP, Chris! Glad they are great for you, and of course, I always appreciate your consistent support : ) : )
Beepeta Rajani Kanth (2 months ago)
Mr.mike ur amazing Can i know ur whatsapp number
ExcelIsFun (2 months ago)
Glad the video is amazing for you, Beepeta!!!!
RJ Bush (2 months ago)
Why would anyone give out their number on a public forum. Don't be surprised if he doesn't.
Yoram Avraham (2 months ago)
!!!!!!!You are the best
ExcelIsFun (2 months ago)
Just trying to have fun with Excel and make the world a better place by providing free Excel Education here at YouTube : ) Thanks for your support, Yoram Avraham!!!!
DIGITAL COOKING (2 months ago)
in my job I got a problem same situation as Commission Rate EX, and ...now I have a solution, good job mike!!!
ExcelIsFun (2 months ago)
Awesome! Do you mean the Variable Commission Rate Example? If yes, here is the real video to watch that shows how to make the actual Lookup Table: https://www.youtube.com/watch?v=eFj1MxraX1Q Thanks for your support, DIGITAL COOKING!!!
Ismail Ismaili (2 months ago)
Hi Mr. Mike again you made it so easy for every single person to understand how to use LOOK up function even if he doesn't know any thing about excel thank you.
Ranjeet Verma (2 months ago)
+Wayne Seymour sir my question is I have 9 digiti MICR Code I want it to break into this in some parts. Like I have breaked it down in left 6 using left function and breaked it down in 3 digits using mid function and took left 6 and mid in vlookup formula all was ok but I want it to break down furthermore. Like this =vlookup (concatenate (left(a2,1),mid(a2,4,3)), table aray, 1,0) Is this possible. Please do this for it will help me. In solving some of the things. Because I am not getting any answers by using this. I want 1st digit and middle 3 digits fixed and all remaining digits should be variable.
Wayne Seymour (2 months ago)
ExcelIsFun  you're welcome
ExcelIsFun (2 months ago)
You are welcome! I did try to break it down and show all possibilities so that who ever watches will have most questions answered : ) Thanks for you for your support, Ismail : )
sahar kathier (2 months ago)
Amazing
ExcelIsFun (2 months ago)
Glad it was amazing for your, sahar!!! Thanks for the comment and support : )
RRR program (2 months ago)
So we are back in future.... Everyone starts excel with Vlookup... Thanks for great examples.... Never imagined vlookup video could be one hour long.. Hah
ExcelIsFun (2 months ago)
One hour!?!? It should have been two hours, but I had to keep it short : ) Thanks you for the support, RRR : )
Luciano (2 months ago)
Hello Mike, you've brought us a few more tricks to boost Vlookup, sensational, you're the guy. Thanks again, top content.
ExcelIsFun (2 months ago)
Glad that there were a few more tricks for you, Luciano!!!! Thanks for you for your support : )
shaver71 (2 months ago)
Hi Mike, I love your Videos. The quality of your videos are very high, some teacher should watch you. Greets
ExcelIsFun (2 months ago)
Thank you for your kind words, shaver71!!! And thank you for your support : )

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.