Love how you & Bill show all the different ways and explain the shortcomings of the formulas. That Lookup in VLookup is a definite highlight!! IsBlank is great too! Thanks for this.
when i first time saw your video sir i was saying with myself what he means by excelisfun nothing has work is fun but indeed it is really it is fun thank you so much for all the inspiration you are giving me everyday to keep going towards my dreams
INDEX and MATCH can do all of what VLOOKUP can do and more, so it is fine to use. The only small drawback is that many more people looking at your formulas would not understand INDEX and MATCH, as compared to VLOOKUP.
Love how you & Bill show all the different ways and explain the shortcomings of the formulas. That Lookup in VLookup is a definite highlight!! IsBlank is great too! Thanks for this.
You are welcome!
I'm falling in love With Excel after watching ur Videos.... 😍😂😉😍 and Like Your Videos Keep doing it.
Awesome!
You are always the best sir. Much respect
Glad the vids are good for you : )
Congratulations guys! Amazing tips to solve this problem!
Glad you like it!
Always amazing! Thanks Bill and Mike!
You are welcome, Kevin!!!!
when i first time saw your video sir i was saying with myself what he means by excelisfun nothing has work is fun but indeed it is really it is fun thank you so much for all the inspiration you are giving me everyday to keep going towards my dreams
Yes!!!!!!! I am happy that you are inspired to get to your dreams!! You will do it : )
ExcelIsFun yes i sure will thank u sir
Wow , Superb trick. thanks for sharing...
You are welcome! Thank you for your support with your comment, Thumbs Up and Sub : )
fantastic to the both of you, but Mike, the lookup function was the STAR for the Video :)
It was a little wild : )
Thank you guys.
You are welcome!!!!
Holy smokes! LOOKUP and ISBLANK for when you want to be ornery. 😄 FASCINATING!
: )
Waw mike I really appreciate lookup("zzz",) always you come up with great and accurate solution
Glad it was fun for you!
i love to listen this intro
it's dueling excel time ♥
Awesome! It is a fun song : )
Thanks. I've seen the "zzz" lookup in other formulas online and didn't understand what it was doing.
Glad it helped!
love you mike girvin
Espetacular. Obrigado.
Glad you like it! : )
Great tricks!
Woo Hoo!!! : )
I
Thanks : )
LOOKUP with the "zzz" is so cool!!!
Yes, but... On an exam, the grader might not even know what it means!?!? : )
"FUNtastic"👌👍
Thanks-erific!!!!
Nice, really like these episodes.
I'm using Index / match instead of vlookup is there any disadvantage of doing that you think?
INDEX and MATCH can do all of what VLOOKUP can do and more, so it is fine to use. The only small drawback is that many more people looking at your formulas would not understand INDEX and MATCH, as compared to VLOOKUP.
I used this in A2 and down: =IF(A2="",B1,VLOOKUP(A2,Sheet2!$A$1:$B$3,2,0))
Cool!
I'm falling in love With Excel after watching ur Videos.... 😍😂😉😍 and Like Your Videos Keep doing it.
: )
I'm falling in love With Excel after watching ur Videos.... 😍😂😉😍 and Like Your Videos Keep doing it.
Excel is fun and love worthy!!!!
Quick Reply ;)😇👍🙆