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

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

718 ratings | 18182 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 (153)
mahesh .n (40 minutes ago)
Excellent explanation thank you very much
George Muirhead (1 day ago)
Thanks Mike your a superb teacher!
ExcelIsFun (1 day ago)
You are welcome, George! Thanks for the kind words! And thanks for your support : )
mostafa4321 (1 day ago)
Excellent presentation Thank yu :)
ExcelIsFun (1 day ago)
I am glad it is EXCELlent for you, mostafa4321!!!! Thank you for the support with your Comments, Thumbs Ups and Sub : )
Graham Waters (5 days 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 (5 days 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 (12 days ago)
Truly brilliant, the vlookup match function just helped me reduce a heavy nested if statement to a much concise formula
ExcelIsFun (11 days 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 (12 days 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 (11 days ago)
You are welcome, sachin! Thank you very much for your support with your comment, Thumbs Up and telling your friends : )
Abdallah Ally (12 days ago)
Thank you Mike. Can you do an INDEX and MATCH tut using office 2016? Again thanks
ExcelIsFun (12 days 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 : )
ASIM SYED (14 days ago)
Hi, looking for your help, can i have ur whatsapp or email? Thanks.
Adrian Paul Layug (16 days ago)
OMG! I learned more a lot in your videos than attending my computer classes! Good job. Continue helping students. Thanks a lot
ExcelIsFun (15 days 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 (16 days 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 (16 days 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 : )
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 (18 days ago)
You are welcome!!! But I am not Mr Excel. That is a different YouTuber called Bill "Mr Excel" Jelen. I am excelisfun : )
Mr. Mike, you are very good. Please know that you have a very curious student in Sierra Leone.
ExcelIsFun (18 days 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 (20 days ago)
I put like before watching ! I know these videos are amazing ! Thanks!
ExcelIsFun (20 days ago)
Thank you, Veronica!!!! Thanks for your support : )
AJ Thompson (20 days 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 (20 days 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 (21 days 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 (20 days 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 (21 days 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 (21 days ago)
You are welcome!!! I agree: VLOOKUP has been around for a long time and it is still useful today : )
NoShadowOfDoubt (22 days ago)
I tend to use fuzzy lookups sometimes to conform to the fuzzy ways some of my co-workers fill their spreadsheets .....
DENNIS ANTWI (23 days ago)
Great video
amit kumar (23 days ago)
Mike, take a bow!
ExcelIsFun (23 days ago)
Thanks for your support, amit kumar!!!!
ExcelIsFun (23 days ago)
I can't do that because it would take time away from making more videos ; )
John Borg (23 days ago)
Always learning. Vlookup(.........)&"" to show a null text string instead of a zero. I never knew that!!! Thanks Mike. :)
John Borg (23 days ago)
Well, that's your channel Mike, for whoever wants to join :) :)
ExcelIsFun (23 days ago)
I love it! There should be a YouTube Channel named excelallthetime : )
John Borg (23 days ago)
Excel all the time :)
ExcelIsFun (23 days ago)
What did you talk about?
John Borg (23 days 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 (24 days 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 (23 days ago)
Wow!!!! That is so amazing : ) You are welcome for the instruction! Congratulations on winning first place in the Excel competition!
Wayne Seymour (24 days 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 (24 days 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 (24 days ago)
ExcelIsFun  I watch all the time
ExcelIsFun (24 days ago)
BTW, did you enjoy this video, or are you just asking questions?
ExcelIsFun (24 days 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 (25 days 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 (24 days ago)
I do not know how to do that. You can try posting your question here: mrexcel.com/forum
Bheemappa N. Bellad (24 days 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 (24 days 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 (24 days ago)
Thanks for your support on each video that you watch with your comments, Thumbs Up and Sub : )
ExcelIsFun (24 days ago)
If I understand your question, then maybe this: =1*1+2*2+3*1+4*2 = 16
Ilya G (25 days ago)
Perfectly explained!
Ilya G (25 days ago)
I am BIG Fan! My name is Ilya Gordeev.
ExcelIsFun (25 days ago)
Glad it was good for you, Ilya G!!! Thanks for the support with your comment, Sub and Thumbs Up : )
Ranjeet Verma (25 days ago)
I have seen your vlookup formula video and I want you to more explain your vlookup formula with mid condition.
Ranjeet Verma (24 days ago)
This video didn't help me because I have seen this earlier.
ExcelIsFun (24 days 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 (25 days ago)
Hello sir I have a problem in Excel could you please help me. In solving this problem.
Ranjeet Verma (24 days 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 (24 days 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 (24 days ago)
Sir it really great video for me and found this more helpful.
ExcelIsFun (24 days 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 (24 days ago)
Did you like this video? Was it helpful to you?
HABIBUL AHMAD (25 days ago)
Excellent video
ExcelIsFun (24 days ago)
Glad it was EXCELlent for you, HABIBUL!!!! Thanks for the support with your comment, Thumbs Up and Sub : )
TMark Group LLC (26 days ago)
Just found your channel and amazed by your content! How can I contact you by email regarding some specific financial workbooks? Thanks!
ExcelIsFun (24 days ago)
Which video are you trying to find a workbook for?
TMark Group LLC (24 days ago)
ExcelIsFun I was just looking for some guidance in locating some specific workbooks you have posted!
ExcelIsFun (24 days 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 (26 days ago)
Thanks a lot !!!!! the video has a lot of details and the explanation goes deeply and steps by step, Muchas gracias!!!
ExcelIsFun (26 days ago)
You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )
Yen# d'life (26 days 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 (26 days 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 (27 days ago)
Great refresher course ....as always easy to understand your explanations. Had forgotten about wild card, thanks for reminding. Thanks Mike
ExcelIsFun (27 days ago)
You are welcome for the VLOOKUP refresher course, Maneshkumar!!!!! Thanks for your continued support : )
Mr. Mickey (28 days ago)
If there is a VLOOKUP God, it'd be Mike. ✔️
ExcelIsFun (27 days ago)
Just a guy having fun with Excel : )
3yebex (28 days ago)
SourceData.xlsx is NOT down below for users to download.
ExcelIsFun (27 days ago)
I am sorry about that. I just posted it - so it should be working now.
Kevin Lynn (28 days ago)
Ironically I think the dislikes, also promote the video... possibly
ExcelIsFun (28 days ago)
Thanks for the encouragement, Kevin Lynn : ) And thankis for your support!
Abdullah Ismail (28 days ago)
hi mike what is your Microsoft office version 2013 or 2016 ?
ExcelIsFun (28 days ago)
The version is Office 365. It is NOT Excel 2016 or 2013.
Mohamed Chakroun (29 days ago)
Amazing like always Master...No comment ... Thumbs up :-) and thumbs down for whom putting thumbs down
ExcelIsFun (28 days ago)
Thanks for your kind words! And thanks for your support, Mohamed Chakroun!
Fuad Khan (29 days ago)
You are the best sir.
ExcelIsFun (29 days ago)
Glad you like the video, Fuad Khan!!! Thank you very much for the support with your comment, Thumbs Ups and Sub : )
Wayne Edmondson (29 days 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 (29 days 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 (29 days ago)
You are welcome, Syed!!! Thank you for your amazingly consistent support : )
Malina C. (29 days ago)
VLOOKUP fun! Thanks, Mike!
ExcelIsFun (29 days ago)
You are welcome, Teammate Malina!!!! VLOOKUP is fun : )
M. SZ. (29 days 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 (29 days 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 (29 days 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 (29 days ago)
You are welcome a lot for the VLOOKUP efforts! Thanks for your support, Rajesh Jawajala!!!!!
Haider Ali (1 month ago)
u got amazing teaching skills...... God Bless You... Thanks for sharing
ExcelIsFun (29 days ago)
You are welcome! I will continue to work hard, have fun and try to make the world a better place : )
Haider Ali (29 days 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 (29 days 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 (29 days 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 (29 days 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 : )
Bihar ke LAl (1 month 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 (29 days 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 Concepts (1 month ago)
Love these tips 💎💎
ExcelIsFun (29 days ago)
Glad you love the diamond tips, Sam Finance Concepts : ) Thank you for your support : )
Ankit Kulshrestha (1 month ago)
I throught I was the champ of Vlookup but looks like I am missing so many things here... Thanks mate
ExcelIsFun (1 month 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 (1 month ago)
you are amazing
ExcelIsFun (1 month ago)
Glad the video was amazing, Mohamed! Thanks for your support : )
clifford (1 month ago)
Thanks Gel!
ExcelIsFun (1 month ago)
You are welcome! Lots of fun Gel Boom examples in this video : ) Thanks for your support !!!!
afzongho (1 month ago)
You Da Real MVP !
ExcelIsFun (1 month ago)
Glad you like the video, afzongho!!!! Thanks for the support : )
Imad Babbili (1 month ago)
Unbelievably professional
LORETTA MAK (1 month ago)
Thank you so much for sharing. May I ask where can I download the SourceData.xlsx file?
ExcelIsFun (1 month 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 (1 month ago)
Nice video as usual. and yes you did it : 500k subscribers very well done and well deserved. thank you.
ExcelIsFun (1 month ago)
You are welcome for the video : ) Thank you for kind words, elhassan!!!!
Tulsidas Jamnani (1 month ago)
Congratulations..... For 500k subscribers...
ExcelIsFun (1 month ago)
Thanks for the Congratulations, Tulsidas, and thanks for your support : )
Leila Gharani (1 month ago)
Congratulations on 500k! This week is VLOOKUP week :) Love the detailed explanation and variations!
ExcelIsFun (1 month ago)
VLOOKUP Week: I love that!!! Thanks for the congrats, Teammate : )
5%LowBattery (1 month ago)
I’m always confused when I come to these videos and see dislike. Like Who does that?
ExcelIsFun (1 month ago)
Thanks for the kind words, 5%LowBattery! You are awesome : )
Chris Mancinelli (1 month ago)
Great examples Mike, very useful!!
ExcelIsFun (1 month 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 (1 month ago)
Mr.mike ur amazing Can i know ur whatsapp number
ExcelIsFun (1 month ago)
Glad the video is amazing for you, Beepeta!!!!
RJ Bush (1 month ago)
Why would anyone give out their number on a public forum. Don't be surprised if he doesn't.
Yoram Avraham (1 month ago)
!!!!!!!You are the best
ExcelIsFun (1 month 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 (1 month ago)
in my job I got a problem same situation as Commission Rate EX, and ...now I have a solution, good job mike!!!
ExcelIsFun (1 month 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 (1 month 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 (24 days 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 (24 days ago)
ExcelIsFun  you're welcome
ExcelIsFun (1 month 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 (1 month ago)
Amazing
ExcelIsFun (1 month ago)
Glad it was amazing for your, sahar!!! Thanks for the comment and support : )
RRR program (1 month 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 (1 month ago)
One hour!?!? It should have been two hours, but I had to keep it short : ) Thanks you for the support, RRR : )
Luciano Moreira (1 month ago)
Hello Mike, you've brought us a few more tricks to boost Vlookup, sensational, you're the guy. Thanks again, top content.
ExcelIsFun (1 month ago)
Glad that there were a few more tricks for you, Luciano!!!! Thanks for you for your support : )
shaver71 (1 month ago)
Hi Mike, I love your Videos. The quality of your videos are very high, some teacher should watch you. Greets
ExcelIsFun (1 month 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.