Civilizations advance because of people like ExcelIsFun. Thank you very much from the bottom of my heart.
@excelisfun2 жыл бұрын
You are welcome, Trader!!! Thanks for your kind words : )
@FidkX11 ай бұрын
You promised FUN and you delivered! Thank you Mr. Girvin!😊
@excelisfun11 ай бұрын
You are welcome for the fun!!!
@libifainitski3812 жыл бұрын
Good day, Professor Girvin. I was your student in the college. Now, I need to remember Vlookup function for my work. I am very grateful that I have this opportunity.
@excelisfun2 жыл бұрын
Yes!!! This is why I post all my Highline Class videos at KZbin for free : ) So you can access them anytime. Glad they are here for you, Libi!!!
@saimumn9252 Жыл бұрын
You give such a hard-working content for free. Ohh, I can't believe it. I bet, you are not only the best teacher but also a highly generous person. Really, you have a GIGANTIC Heart.
@excelisfun Жыл бұрын
Yes, sir! It is my duty as a human on the planet earth to try and make the world a better place. This is one way I try to do that. I am happy the content helps : )
@peterwoods352 жыл бұрын
This is hands-down the best excel tutorial I have ever seen. Congratulations!
@excelisfun2 жыл бұрын
Glad it was helpful!
@SpeakingAmericanTruth Жыл бұрын
This video just saved me 8 hours of work.
@excelisfun Жыл бұрын
Yes!!! Saving lots of hours of work is why I have been posting for the last 15 years here at KZbin lol
@packetlosss5269 Жыл бұрын
I'm from Bangladesh. You are my 1st and best Excel teacher... Immense respect for you......wish you and your family good health.
@excelisfun Жыл бұрын
Thanks for the well wishes! Glad the videos help : )
@MonirulIslam-zj3ve6 жыл бұрын
Sir, Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.
@excelisfun4 жыл бұрын
Dear Md. Monirul Islam, Thank you very much for your kind words and support in telling others about the free Excel Education that I provide to the world : ) Sincerely, Mike excelisfun Girvin
@heatherbellbikes2 ай бұрын
This was great for explaining and using VLookup. I’ve tried and failed a number of times at understanding it. I love that you reinforce many of the things we learn throughout the lesson and in subsequent lessons. However, in the homework section, which I’d nailed in every lesson until I got to the very last one in this class when you mention about what to return if the cell is blank. I simply couldn’t remember how to use isblank and ifna as you kind of glossed over it in the previous lesson and didn’t show how to use it with vlookup, so this was a really tough one. In the end, I had to keep pressing F2 on the answers page. Now that I have done it a few times, I have a sheet at work that I can test it on multiple times for practice. I’m sure it’ll became second nature. I’ve learned so much from these lessons and hugely appreciate that they’re free. Knowledge is power.
@excelisfun2 ай бұрын
Heather Bell Bikes (love the name), just put VLOOKUP in the first argument of INFA and the two double quotes "" in the second argument. Bam: that should work : )
@heatherbellbikes2 ай бұрын
@@excelisfun Perfect, thanks for the help. I was so confused! I like to cycle, hence the name 😊
@excelisfun2 ай бұрын
@@heatherbellbikes Excel and Bikes go together perfectly : )
@heatherbellbikes2 ай бұрын
@@excelisfun Just not at the same time, though!
@ardy.m62676 жыл бұрын
This is a very expensive knowledge to get in college right here for free. YOU ARE THE REAL DEAL, PLEASE MAKE MORE. Your channel is worth subscribing.
@excelisfun6 жыл бұрын
Glad you like it! It is expensive because each time you watch you have to click Thumbs Up and leave a small comment - but I guess it is better than paying money : )
@badrinathmoorthy4 жыл бұрын
Mike no one can teach/share knowledge better than you,not even close.With each video m gaining confidence to use Excel like a pro.Thanks
@excelisfun4 жыл бұрын
Thank you for your kind words, vivek!! Thanks for your support on each video with a comment and thumbs up: it helps to promote the videos and get this free Excel Education to more people in the world!!!
@Chamchijjige4 жыл бұрын
I lately found you. Just basic level 14th video i completed. And yesterday you saved my life. Thank you very much.
@excelisfun4 жыл бұрын
You are welcome for the "saved my life" fun, Chamchijjie!!!
@muhammadyounas9129 Жыл бұрын
Thank you from the depth of my heart, really one can not find any video better then these videos present on this channel❤❤❤
@excelisfun Жыл бұрын
I am glad to help : )
@andreacarr31997 жыл бұрын
You are a BORN teacher!!! The way break things down into such simple to understand concepts is FANTASTIC!!!!
@excelisfun7 жыл бұрын
Yes! I am glad that this all works for you : ) Thank you for your continued support!!!!!
@TurboTeen2910 ай бұрын
Hello @mike sir you videos are far more better than some of the institute of my region, Thankyou very very much for your support and my hearty gratification to you....
@excelisfun10 ай бұрын
You are welcome very much!!!!
@michvmmify6 жыл бұрын
This is the most comprehensive and engaging Excel tutorial that I have come across. Thank you very much for your commitment to teaching and helping others to master material that can oftentimes be difficult to maintain an interest in. Much appreciated
@excelisfun6 жыл бұрын
You are welcome very much, michvmmify! I can provide this free education because of support from viewers like you with your comments, Thumbs Ups and Subs : )
@deveshdangi72095 жыл бұрын
Thank you sir for another charming video of VLOOKUP!! what an excellent up-gradation to the IF function. Once again thank you for all your efforts.
@excelisfun4 жыл бұрын
Yes, a very good upgrade : )
@edutube26863 жыл бұрын
I really loved the way you teach. I wish I could have had you as my teacher for all the courses that I learned till and going to learn in future.
@excelisfun3 жыл бұрын
I will be here at KZbin for you!!!!
@timpt4 жыл бұрын
I felt so clever when I created a massive string of IFS as a formula for my gradebook. I've seen other videos on VLOOKUP, but this is the first time it has ever made sense to me. Thank you! Also, I'm thinking back on how much time I've lost because I didn't go down to the last cell and hit F2 to check the formula. You really hammer that point home in these videos.
@excelisfun4 жыл бұрын
Glad to help, Tim : )
@mr.chinmayajoshi2688 Жыл бұрын
Great video. Your homework problems are really awesome and helpful. God bless you. ❤️😭❤️
@excelisfun Жыл бұрын
Homework is fun : )
@mr.chinmayajoshi2688 Жыл бұрын
@@excelisfun indeed
@pmsocho7 жыл бұрын
Thanks for the comprehensive tutorial! I wish I were one of your students when I learnt Excel 15 years ago!
@excelisfun7 жыл бұрын
You are welcome! I wish i had a good teacher also back in the early 90s...
@behzatcetin348 Жыл бұрын
Very well explained. Thank you!
@excelisfun Жыл бұрын
You are welcome!
@melross76403 жыл бұрын
Thank you sooo much. I've been trying to find how to do this and no other video I've seen details it like you do. You are my go-to guy now :)
@excelisfun3 жыл бұрын
Glad to help. I have been providing detailed Excel for 13 years here at KZbin. Nice to connect with you!
@SFD-Horses3 жыл бұрын
I just wanted to say thank you for this. You actually DID make this fun to learn. I've been a subscriber for a while but only come back when I'm stuck with something... Now, I'm interviewing with a company that requires me to know what a H&V lookup was. I've never used it before. THANK YOU! Your video may have landed me this job! PS I even did the homework. :)
@excelisfun3 жыл бұрын
I am happy to help. This is what I have been doing for 13 years: fun with excel to get jobs, keep jobs and get promoted quickly. Post back and let me know about the job : )
@SFD-Horses3 жыл бұрын
@@excelisfun I will Thank you. 2nd interview is tomorrow afternoon.
@excelisfun3 жыл бұрын
@@SFD-Horses goo luck with the 2nd interview!!!
@SFD-Horses3 жыл бұрын
@@excelisfun THANK YOU! I accepted their offer on 12/3! And they have Office 365 which means I can use your SEQUENCE tutorial. I'm experimenting so I am proficient on my first day.
@excelisfun3 жыл бұрын
@@SFD-Horses You are going to do awesome!!!!
@twindaykonii75333 жыл бұрын
Thank you so much! I always remember to click F2 to verify now. It's like whenever I answer the Homework, I can hear your voice. You are the best teacher! Even like me, a non-native English speaker, I am able to understand your teaching very well!
@northshoreunitarians64173 жыл бұрын
Great video, as always! I think I finally have it locked into my brain the difference between approximate match and exact match in VLOOKUP. (For some reason, I sometimes forget what those mean -- but now it's clear).
@excelisfun3 жыл бұрын
Awesome!!! Knowing that is crucial to being great with Excel. : )
@tomjun89456 жыл бұрын
I wanted to say thank you for all of your videos because it have helped me and all my friends get through many of our college classes. Also, because of your amazing informational videos on here it has help me at my current job as an accountant. Each time when I need help I know I can refer to your KZbin channel and I can always count on a video you published to help me out. Thank You and keep up the good work.
@excelisfun6 жыл бұрын
You are welcome! I am glad that the videos help you in school and in your job. Be sure to help promote the excelisfun channel by always clicking Thumbs up, leaving a comment when you are inspired and telling all your friends to subscribe and learn for free : )
@Chamchijjige4 жыл бұрын
Even before watching worth to say thank you.
@excelisfun4 жыл бұрын
You are welcome!
@TheLegendLeviathan3 жыл бұрын
I'd consider myself an excel pro... But these videos are absolutely amazing for reviews and potentially picking up new tidbits.
@khalidamao7 жыл бұрын
You the best,just a few days of watching all your Excel Basics and i feel so accomplished already...You the BEST ,Thanks
@excelisfun7 жыл бұрын
That is why I post so you and others can have fun and become proficient with Excel!! Thank you for your support with your comment, Thumbs Up and Sub : )
@mostafaahmedzein4505 жыл бұрын
I love your end sentence so much " Because there's always lots more videos to come from excelIsFun"
@excelisfun5 жыл бұрын
Glad you love it, Mostafa!!!!
@datascientistoflife85505 жыл бұрын
You make us habitual of working on excel like we working professionally..
@excelisfun39035 жыл бұрын
Yes! Working professionally in Excel is efficient, profitable and fun!!!! Thanks for your support, Sever Engineer, with your comments, Thumbs Ups and your Sub : )
@kimhare7823 Жыл бұрын
Amazing explanation!
@excelisfun Жыл бұрын
Glad it helps!!!!
@SK-bv6yd3 жыл бұрын
BIg thank you to the best excel teacher ever!
@nabilnabil18243 жыл бұрын
I love how you explain vlookup It's very easy for beginner like me to understand
@krishnakishorepentapalli7 жыл бұрын
Thank you very much for these classes. Very easy to understand and practise through your homework tasks. Appreciate your kind service to the society. We will forever be indebted to your gesture.
@excelisfun7 жыл бұрын
You are welcome! It has been my goal for almost 10 years at KZbin to bring Excel to the world. No need to be indebted, just pay back with a Thumbs Up and small comment on each video that you watch - it helps a lot : )
@sair10875 жыл бұрын
You are amazing! I've learned a lot from your videos and about to attend an Excel test for a possible employment opportunity. Thanks a ton!
@anderson40th605 жыл бұрын
Awesome overall. Homework was an excellent challenge as well and helped push my understanding to a new level. Enjoyed the mixing of IF and VLOOKUP. Hard work pays off! Thanks!
@excelisfun5 жыл бұрын
Glad the video, notes, Excel files, homework and hard work pay off!!! Thanks for your support with your comment, Thumbs Up : )
@ismailismaili00717 жыл бұрын
As i know that Vlookup is one of the most powerful functions thank u Mr. Mike for showing up with explaining how it really works
@excelisfun7 жыл бұрын
You are welcome!
@nickhanley48165 жыл бұрын
Hey Mike, In Sheet HW(1an) the solution in cell B8 should be =VLOOKUP(A8,$A$11:$E$17,3,0) as opposed to =VLOOKUP(A8,$A$11:$E$17,2,0). Thanks again for your amazing work, I am smashing through this series and loving every minute!
@excelisfun5 жыл бұрын
Thanks for the editing, Nick! I have updated the file so our Teammates will have the correct file : )
@ezgikocak74572 жыл бұрын
Amazing. So clear. Thanks for your effort. :)
@excelisfun2 жыл бұрын
You are welcome for the clarity!!!!
@nagizadeorxan Жыл бұрын
another great video for understand how the function works, thanks for great lesson!
@excelisfun Жыл бұрын
You are welcome!!!!
@sonialorenzo92236 жыл бұрын
This video has helped tremendously this week. I’m your #1 fan. I have everybody watching your videos.
@excelisfun6 жыл бұрын
Glad it helps! Thanks for telling people about this free Excel Channel! Thanks also for the support with your comment, Thumbs Up and Sub : )
@gauravchaudhry71332 жыл бұрын
You are a great teacher.... God bless u🙏🙏
@mamadoubah36863 жыл бұрын
Hello Mike! Amazing content! You are a great trainer. Thank you so much!
@trustinwwjd19975 жыл бұрын
Whoa,,, thanks so much Mr. Girvin for your such passionate teaching on the ExcelIsFun VIDS,,,, GOD bless for all your good works,,,,
@excelisfun5 жыл бұрын
You are welcome, TRUSTin WWJD!!!! I am happy to post these for you : )
@surbhigoyal2785 жыл бұрын
Hey Thank you so much I learned a lot from your videos. You are simply awesome👏👍
@excelisfun5 жыл бұрын
Glad the videos help, Surbhi!!! Thanks for the support with your comment, Thumbs Up and Sub : )
@kisslaci366 жыл бұрын
Great job again. In the last HW for this sheet I actually used different combination of the functions, than in your resolved version, but yours was a bit shorter. But I got the same values, so here's for practicing and developing intuition.
@excelisfun6 жыл бұрын
I love it! Creating your own solution in a new way is TRUE fun : )
@anuragmishra17016 ай бұрын
GOLD video thanku sir!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@excelisfun6 ай бұрын
You are welcome!!!!!!!!!!!!!!!!!
@simoiyahector-morales95217 жыл бұрын
Sir I can't compliment you enough, thanks for your teachings. I feel so expert at excel. Keep up the great job.
@excelisfun7 жыл бұрын
You are welcome! Thank you for your support with your comments, Thumbs Up and Sub : )
@sorenzollamas7 жыл бұрын
As usual, mind blown. Thanks.
@excelisfun7 жыл бұрын
Yes, Mind Blown is a positive direction is always good!!! Thanks for your support : )
@_anbu_16296 жыл бұрын
VLOOKUP is an awesome function))) it’s so useful!!!! Thank you for lesson!!!!!
@excelisfun6 жыл бұрын
You are welcome, _AnBu_!!!! Thanks for your support : )
@Nyuklehead4 жыл бұрын
Thank you so much for this fantastic lesson! Can't wait to see what Excel magic tricks you'll teach me in the next video.
@excelisfun4 жыл бұрын
Must have VLOOKUP in your bag of tricks. With many more to come, Nyuklehead!!!
@mcloughman5 жыл бұрын
Man of the People!
@excelisfun4 жыл бұрын
Just a guy having fun with Excel : )
@arahmanabdelrahman66616 жыл бұрын
Thanks Very much I do like I used the if function for categorizing my students marks, something which is much vulnerable to human error I’m from now going to enjoy the vLookup
@cindysterling72243 жыл бұрын
Thank you for these video tutorials! they are amazing! You rock :)
@excelisfun3 жыл бұрын
You are welcome, cindy!!!!
@chandu7spark4 жыл бұрын
Sir by watching your videos it fees me like excel is very easy. Tanq You. :)
@excelisfun4 жыл бұрын
Glad to help you feel the power and easiness of Excel, Bharat!!
@joramirez1593576 жыл бұрын
Made life so much easier!
@excelisfun6 жыл бұрын
Glad it helped! Thanks for the support with your comment, Thumbs Up and Sub : )
@Whyvardhann6 жыл бұрын
Indeed One of the most important!
@excelisfun6 жыл бұрын
For sure, VLOOKUP is often used, solves many Excel problems and employers love to ask potential employees if they know what it does : ) Thanks fro your support !!!
@heatherbellbikes2 ай бұрын
Handy tip: don’t save the workbooks as you go along. That way you can re-open them and do all the exercises again and again for a refresher and to lock in what you’ve learned. Only save when you first open the workbook after downloading so you don’t get the Edit warning each time you open it.
@excelisfun2 ай бұрын
Absolutely!!! Do this forever 100% of the time for every file that you ever download from internet. I taught this mandatory computer skill in the early videos in this class.
@heatherbellbikes2 ай бұрын
@@excelisfun I have had to go back to number 16 as the cell reference thing has been bamboozling me and not having saved it is really helping as I did have to try and figure out what I need to remove andI have to work hard at doing the exercises again. It still bamboozles, to be fair, but I’m making minor progress.
@ΘεοφιλοςΓεωργιαδης-ζ5τ3 жыл бұрын
Great Work. It has helped me a lot to understand lots of features of Excel. I wanted to point out that there is a problem when trying to download the course excel file of this video. I was able to download the excel files from your previous videos but not this one and i observed that the same problem appears in many of the following videos.
@tocodelray4 жыл бұрын
Mind blowing stuff! This is fantastic.
@excelisfun4 жыл бұрын
Glad you like it!!
@Kizo_556 ай бұрын
Thank you!
@excelisfun6 ай бұрын
VLOOKUP you are welcome!!!!
@deadspace491865 жыл бұрын
Another great lesson! Thanks a lot! Thumbs up!
@excelisfun5 жыл бұрын
You are welcome, Elmar : ) : )
@theresalaureano39034 жыл бұрын
Thank you so so so much!! You are such a blessing!!!
@excelisfun4 жыл бұрын
You are welcome so much, Theresa!!!
@rameshmenon10696 жыл бұрын
u r a master teacher ..god bless u....giving free knowledge ..can u teach how to make complecated forms in excels with rows and coloums..merge ,center ,orientation of text....we many times receive forms in excel...with too many data...i always wonder what excel tools are used ,,,to create such forms..
@abdullahaladib40952 жыл бұрын
great video
@excelisfun2 жыл бұрын
Glad it helps!!!!
@ShahinMahmudhtw5 жыл бұрын
Thank for your excellent tutorial
@excelisfun5 жыл бұрын
You are welcome, Shahin : ) : )
@ghost83392 жыл бұрын
Loving it!, Thank you sir
@maheshchandpradhan60604 жыл бұрын
Very good I learnt about vlook up table and its utility.
@excelisfun4 жыл бұрын
Glad it is very good for you, Mahesh : )
@Runner19695 жыл бұрын
Thank you for your step by step!! SO helpful!!
@excelisfun5 жыл бұрын
You are welcome for the so-helpful, Cathy!!! Thank you for the support with your comment, Thumbs Up and Sub : )
@markpodesta46057 жыл бұрын
Very good video. I use VLOOKUP all the time.
@excelisfun7 жыл бұрын
Glad it is good. Thanks for your support : )
@lameessy23025 жыл бұрын
Thanks a lot for all lessons you make.❤
@excelisfun5 жыл бұрын
You are welcome for the lessons that I make, Lamees!!!! Thank you for helping support my efforts with your comments, thumbs up and of course your Sub : )
@lameessy23025 жыл бұрын
@@excelisfun Thanks for your nice words, you are the best in teaching.. I was looking for someone like you to study excel. I have learned a lot just from basics lessons.. How if I continue with advanced lessons...
@excelisfun5 жыл бұрын
@@lameessy2302 , Here is the playlist of my advanced class: kzbin.info/aero/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw But please help with comments and thumbs up on each video. It is the pay you can give for the class : )
@husaamawad14634 жыл бұрын
Extremely excellent
@febrianto9845 жыл бұрын
Thanks for today lesson
@excelisfun5 жыл бұрын
You are welcome, Febri!!!
@SyedMuzammilMahasanShahi7 жыл бұрын
EXCELlent video. Thanks Mike
@excelisfun7 жыл бұрын
You are welcome!
@rrrprogram86677 жыл бұрын
Great as usual mike .... this channel is a gold mine ..... explore to ur satisfaction.....But this will turn into a diamond mine after March :D
@excelisfun7 жыл бұрын
Thank you for your kind words!
@mburke19887 жыл бұрын
You are the best trainer! Love all your videos! Can you recommend a good KZbin channel for SQL tutorials? Thanks so much!!!
@excelisfun7 жыл бұрын
I do not know a good one for SQL. Glad you like the Excel videos. Thank you for your support with your comment, Thumbs Up and Sub : )
@Ecoippo4 жыл бұрын
First of all, a big thank you for all this content, you're doing a life-saving and a time-saving job :) I was wondering in the 4th example, if bonus commission should be related to the wage of each employee. I mean, the logic is the same, we should find out if employees achieve to sale 10.000 or more to get a bonus, but the actual amount of the bonus shouldn't be related with a column named "wages" instead of sales? e.g. employee has a wage of 3000$ per month, if he sales 14.000, he should have taken a bonus of 1%, i.e. 30$. Hoping for your response!!
@rakeshdevendra6 жыл бұрын
i got ur channel link from a twitter mention...have to say u r a goldmine of excel.
@excelisfun6 жыл бұрын
i got ur channel link from a twitter mention...have to say u r a goldmine of excel.....is there any way that i can give donation...that wont b much as i m still a student,but still i would like to donate.....me from INDIA
@excelisfun6 жыл бұрын
No need to donate, but PLEASE click Thumbs Up on each video that you watch and leave a small comment on each video that you watch - that helps me and is better than a donate : )
@excelisfun6 жыл бұрын
No need to donate, but PLEASE click Thumbs Up on each video that you watch and leave a small comment on each video that you watch - that helps me and is better than a donate : )
@abdullahesmail96816 жыл бұрын
thanks a lot from Egypt
@excelisfun6 жыл бұрын
You are welcome! Thanks for your support : ) It helps a lot!!
@begaimkarynbaeva70715 жыл бұрын
excellent explanation! love it!
@DewinaBu5 жыл бұрын
Amazing! I love excel, thank you so much, again! =)
@excelisfun5 жыл бұрын
Yes!!! I love to hear that you love Excel, Debry!!!! You are welcome so much again! Thanks for your continued support with your thumbs ups and comments : )
@BK-kp6rr6 жыл бұрын
Thanks again. Excellent!
@excelisfun6 жыл бұрын
You are welcome again !!! Thank you for your support!
@pxeo_erkan7 жыл бұрын
Mike, with all respects, thank you.
@excelisfun7 жыл бұрын
You are welcome! With all respect, be sure to click that Thumbs Up and leave a comment on each video : )
@pxeo_erkan7 жыл бұрын
Already gave that Thumb :) and wait the next one impatientlly
@excelisfun7 жыл бұрын
Thanks you do much! I can't wait till the next one either : )
@wolfpackmre6 жыл бұрын
Amazing as usual. Was looking forward to learning this. Curious to see if there is a video that will go over Index-Match, since I've heard it's sometimes preferable to VLOOKUP. Thanks a bunch!
@excelisfun6 жыл бұрын
I am glad that the videos help! Thanks a bunch for clicking Thumbs Up and leaving a comment on each video that you watch as support for the free resource. And Sun so you always know when new vids come out. INDEX and MATCH? Not in this class, but I have 100s of vidoes of that topic already. Here is a great "getting started" one: kzbin.info/www/bejne/a5vFf4SdZ9WWqLc
@Mtuji16 жыл бұрын
Amaaaaazing videos. Thank you thank you. I now love excel
@excelisfun6 жыл бұрын
You are welcome! I am glad that your are falling in love with Excel. Thanks for your support with your comment, Thumbs Up and Sub : )
@bavajikj32674 жыл бұрын
Great job, appreciate it sir
@excelisfun4 жыл бұрын
One of the most important Excel functions for last 30 years: VLOOKUP. Glad you like it all, bavaji : ) : )
@MrRamonm7186 жыл бұрын
excellent tip with vlookup
@excelisfun6 жыл бұрын
Glad it helped, MrRamonm718!!! Thanks for your support : )
@shrek87222 жыл бұрын
Loved the hw no 3
@krn142427 жыл бұрын
Thanks Mike. (9 Examples). :)
@excelisfun7 жыл бұрын
You are welcome SQRT(81) times, WRH!!!!
@johnborg54197 жыл бұрын
Thanks Mike. Very well explained :)
@excelisfun7 жыл бұрын
You are welcome!
@JG-hh5rp5 жыл бұрын
Wow awesome... thank you so much
@excelisfun5 жыл бұрын
You are welcome so much, Maha!!! Thanks for your support with your comment, thumbs up and your Sub : )
@mohamedchakroun49737 жыл бұрын
Thanks mike for this review very fun
@excelisfun7 жыл бұрын
Glad it wad fun! Thank you for your support : )
@gwadaguadeloupe43086 жыл бұрын
Thank you for this great Video. I am not sure how reduce my time working on 2 differents workbooks. some infos I need are in severals cells in the same worksheet from workbook A. And the lookup value is the chq number. I would like vlookup to gather for instance the amount, payment date, bank ref, customer ref from Workbook A and find all these values and populate them on Worbook B in specific cells that need to be completed with the same info. I hope this makes sense. Can V-lookup do this? Thanks a million.
@girishdabholkar73755 жыл бұрын
Sir you are really great, thanks
@excelisfun5 жыл бұрын
You are welcome, Girish!! Thank you for the support with your comment, Thumbs Up and Sub : )
@yeahmed_5 ай бұрын
Thank you very much ^_^
@excelisfun5 ай бұрын
You are welcome very much!!!
@AbelTravel6 жыл бұрын
Thank you for the video on IF and IS functions. Mike, when I downloaded the file to follow along I wasn't able to type in any cells. The formulas were different.
@excelisfun6 жыл бұрын
I have no idea what is happening. What version of Excel, what country are you in?