As an instructor,showing things that go wrong first gives students a better sense of WHY they need to learn an alternative or learn it the way its supposed to work. Some bad habits get so ingrained that unless theres a reason, they keep doing things the old way. So kudos to you.
i have to say this is by far THE BEST tutorial on index match i have seen. So clear, so simple to understand. Your teaching style and accompanying graphics and cheat sheets make it easy to follow. Thank you!!!
OMG, thank you SO much for this video! Back story: I used INDEX MATCH several years ago at a previous job, many times for a few weeks and then not at all since then. Now at my new job I absolutely _KNEW_ that this was the function I needed and I read several blogs and watched some videos about how to do it, but nothing was working right. This video explained it all so well and 10 minutes after watching it I solved the issue I was having for weeks and you've saved me!!!!! *THANK YOU SO MUCH!!!!!!*
I am a very competent Excel user when people give good wxplanaon how to do something. I've found that most tutorials go to fast or don't explain every step. I felt you did a great job of explaining and I appreciate what you were able to teach. Thank you.
This is the best explanation ever. Thank you - I'm using it to compare inventory audit sheets to a list of 26,000 items unaccounted for. Joy. This makes that task digestible! Thank you again.
for years ive been seeking an explanation of how to use index and match that landed for me, and this explanation landed, great explanation and visuals, thank you so much
It was my first time to be given those functions of index and match exercise without teaching but later I thought all class after watching this video. much love brother from Uganda.
I just reviewed the accompanying workbook you provided. I believe your generosity with your knowledge to be one of the finer examples of what the internet was intended to be and I loathe the times I have fallen short of that expectation. I truly appreciate you, your work, and for reminding me to be human on the internet.
I think this is probably the best Excel training video I have ever watched in my life (and I've watched a LOT of them). Thank you for the spreadsheet download to follow along, for being so clear and for highlighting everything you do (and for the added "Anchor" and "Tab into" tips). You are a great teacher! This helped me understand so much better!
I completely agree I've watched so many excel tutorials and never got it. I watched this the first time and got it right away. The worksheet to practice and follow along helped a lot! Thank you so much! Hitting the subscription button immediately!
I couldn't get index match for years, I finally understood it and actually used it by watching your video. This is one of the best I have seen on how this index match works. Thank you so much!!!
Thanks buddy. You just saved me about 5 hours of work. I had 58,000 rows of data with about 200 columns each from which to extract data, this technique did exactly what I wanted.
I've gone to Exceljet so many times since I don't use INDEX/MATCH frequently, but you just explained it in a way that I'll never forget. Thank you so much!
I have never come across any excel tutorial UA-cam video that is as informative and easy to understand as yours. BIG THANK YOU for sharing all these VALUABLE information to the viewers. I've always struggled to understand these formulas as I never learnt them in my uni, but I need to use them at workplace. THANKS AGAIN!
OMG. You are a life saver. I was struggling to understand what is INDEX MATCH and I’ve read notes and watch other videos, I still don’t get it. Thanks for breaking it down to such bite size, it’s quite idiot proof. I have just subscribed to this channel! Thank you!
Excellent! I remember the first time I saw INDEX/MATCH formulas - was totally blown away with the power of this formula. Was used to bring back consumption costs - electricity/renewable energies sector.
Absolute ledgend, i'm currently studying online and they have privided us with the slideshows of the lesson but no one to present them, actual explanations help immensely, Thank You!
I know I've commented this video before, but again, thank you so much for your Excel videos! Your work has been a significant help to me. Thank you so much!!!!!
I've never heard of INDEX MATCH formula, until recently. But only with your video I can understand how to use it and write formula correctly! you explained it very clearly and easy to understand. Thank you very much!! I appreciate your generosity sharing these knowledge. Thank you for sharing the Excel file as well. I have liked and Subs as well.
This is such a great tutorial on INDEX MATCH. I love that this broke down each function's definition and even put the requirements in layman's term for anyone without coding experience. The snippet about using data validation for pulling up values was brilliant. Definitely is another great idea for my toolbox. Thank you for the awesome, well-articulated video.
Hi Jon, I'm taking an intro to accounting spreadsheets course online, and it has been kicking my butt. We only have one video lecture a week and it is about 20 minutes, and doesn't nearly explain the information like you do. Thank you for taking the time to create these videos for us, it has already taught me a lot and made these nested functions make sense. :)
Perfect!!!! Perfect!!!! Perfect!!! I was struggling with finding the perfect document to work with, and this INDEX/MATCH UA-cam video appeared.I am now able to understand this content very clearly, now I know that my students will also feel confident once I share the INDEX/MATCH examples with them.
LOVED THE CONTENT AND YOU EXPLAINATION ALOT, ONE MORE THING I HAVE NOTICED IS THE WAY YOU ARRANGE THE THOUGHTS TO INSTALL THE FORMULATS CORRECTLY IN OUR MINDS THANKS ALOT
i literally solved my excel / google sheet dilemma with the help of this tutorial! index + match! such a big help. thank you Jon for your demonstration, will surely watch your other videos! God bless you.
Was having issues with getting VLookup to work, and this option for Index/Match was perfect! Using it to create a table to calculate price for leather goods--and using a table with leather name & price and putting into a formula to calculate cost for each item configuration (up to 6 pieces and 6 types of leather per an item...).
Very professional and well created/produced. The circling of the array or individual cell is a nice effect and visual. Compared to some "how to" videos where the person records themselves on a cell phone this is top notch.
Much appreciated - I used to utilize Index/Match frequently, but it had been a while and I was making a mistake (forgot to anchor...). This explanation/tutorial is waaaayyyyy better than whatever I read/watched several years back, you're a rockstar.
Hi Jon!!! One grateful new subscriber here 😊. I have been looking on how to use this same formula so I have watched multiple videos here in youtube and you are the only one who helped me the most in understanding how this function works . Please do not stop making videos like this because you are one of a kind when it comes to making the viewer understand what they wanted to know . Thanks and have a great day !
Good video. Was having trouble understanding the function after reading a bunch of different sites but was able to use index match after watching the video. Thanks!
Thank you so much! This video solved the problem that I have been working on for 2 days toggling with vlookup function . Silly me. Very helpful and easy to follow.
The best explanation from among hundreds of Excel Masters.... I just love the way you explained... It was awesome... I just subscribed and also refer many of my friends..... Great Work - Jon..... Wonderful... Keep it up.....
Thank you for this. Great video to follow along. Helped me with my issue of pulling the data of only a few countries out of a global list. Much appreciated!
Great video! I have always used VLOOKUP and have implemented work-arounds for looking left or whatever. You have prompted me to revisit INDEX-MATCH. Thanks!
4 роки тому+1
I've watched several tutorials before this one and couldn't understand how this works. The cheat sheet helped a lot. This is the best tutorial I came across and managed to make my formula work. Thanks, Jon!
Jon I love your teaching style, mentioning all the hotkey shortcuts and going through each portion of functions along with a file to follow along. Perfect!!!
TY, TY, TY. I'v been trying to wean myself off V & H lookups but I'm having the hardest time grasping how Index Match works. Your video was extremely methodical and easy to comprehend. 🤞🤞🤞Let me go try it
As an instructor,showing things that go wrong first gives students a better sense of WHY they need to learn an alternative or learn it the way its supposed to work. Some bad habits get so ingrained that unless theres a reason, they keep doing things the old way. So kudos to you.
True
i have to say this is by far THE BEST tutorial on index match i have seen. So clear, so simple to understand. Your teaching style and accompanying graphics and cheat sheets make it easy to follow. Thank you!!!
]
OMG, thank you SO much for this video! Back story: I used INDEX MATCH several years ago at a previous job, many times for a few weeks and then not at all since then. Now at my new job I absolutely _KNEW_ that this was the function I needed and I read several blogs and watched some videos about how to do it, but nothing was working right. This video explained it all so well and 10 minutes after watching it I solved the issue I was having for weeks and you've saved me!!!!! *THANK YOU SO MUCH!!!!!!*
This has to be the best channel for excel tutorials. Very clear and easy steps to follow. You don't over complicate it. Thank you
That's the best one I have came through... and you exactly know what we need. A 'Thanks' would just be a very little expression of my gratefulness.
You're very welcome! 😀
I am a very competent Excel user when people give good wxplanaon how to do something. I've found that most tutorials go to fast or don't explain every step. I felt you did a great job of explaining and I appreciate what you were able to teach. Thank you.
I must say this is the best index match explanation I've seen. Seriously. Thank you.
yeahh, other youtuber just doesnt work for me
I've seen other Excel teaching videos. This guy is the best in every way, especially on complex functions. The materials he provided were excellent!!
I feel more and more like a magician every time I watch your tutorials. Great content!
This is the best explanation ever. Thank you - I'm using it to compare inventory audit sheets to a list of 26,000 items unaccounted for. Joy. This makes that task digestible! Thank you again.
Glad it was helpful! 😀
I've watched many videos of excel,
But this guy teaching way is so amazing
The way he explain excel function/formula is so helpful
Happy to help, MushtaQue! 😀
for years ive been seeking an explanation of how to use index and match that landed for me, and this explanation landed, great explanation and visuals, thank you so much
It was my first time to be given those functions of index and match exercise without teaching but later I thought all class after watching this video. much love brother from Uganda.
Best explanation on youtube for INDEX MATCH
Thank you, Abdelaziz! 😀
I just reviewed the accompanying workbook you provided. I believe your generosity with your knowledge to be one of the finer examples of what the internet was intended to be and I loathe the times I have fallen short of that expectation. I truly appreciate you, your work, and for reminding me to be human on the internet.
I think this is probably the best Excel training video I have ever watched in my life (and I've watched a LOT of them). Thank you for the spreadsheet download to follow along, for being so clear and for highlighting everything you do (and for the added "Anchor" and "Tab into" tips). You are a great teacher! This helped me understand so much better!
Wow, thanks for your feedback Margaret! 😊
I completely agree I've watched so many excel tutorials and never got it. I watched this the first time and got it right away. The worksheet to practice and follow along helped a lot! Thank you so much! Hitting the subscription button immediately!
Wow amazeballs!! You showed me VLookup and now you've shown me Index Match. Thank you very much.
I watched several videos before stumbling upon this one. This is the best and easy tutorial on index matching. Thank you Jon
You are best Teacher. I now clearly understand what Index Match Function Does. Thanks a Ton.
I couldn't get index match for years, I finally understood it and actually used it by watching your video. This is one of the best I have seen on how this index match works. Thank you so much!!!
You are So AWESOME !!! In one video you explained the most important and practical stuff!! THANK YOU!!!
The best and most explicit tutorial of Excel that I have found so far. A lot of thumbs up! Thank you so very much Jon.
Thanks buddy. You just saved me about 5 hours of work. I had 58,000 rows of data with about 200 columns each from which to extract data, this technique did exactly what I wanted.
I've gone to Exceljet so many times since I don't use INDEX/MATCH frequently, but you just explained it in a way that I'll never forget. Thank you so much!
I have never come across any excel tutorial UA-cam video that is as informative and easy to understand as yours. BIG THANK YOU for sharing all these VALUABLE information to the viewers. I've always struggled to understand these formulas as I never learnt them in my uni, but I need to use them at workplace. THANKS AGAIN!
OMG. You are a life saver. I was struggling to understand what is INDEX MATCH and I’ve read notes and watch other videos, I still don’t get it. Thanks for breaking it down to such bite size, it’s quite idiot proof. I have just subscribed to this channel! Thank you!
after a week, you are the only one I got the index& match function with data validation from,,BIG THANKS
Well organized and explained, you really brought us on why Index&Match is better. highly appreciated.
Glad you liked it 😀
Excellent! I remember the first time I saw INDEX/MATCH formulas - was totally blown away with the power of this formula. Was used to bring back consumption costs - electricity/renewable energies sector.
Seen many Index/Match tutorials, this is the best. Thank you Jon
It is no exaggeration that I got my concepts clear of combine of two function. Thanks
I was lost till i saw this video, can't be explained any clearer. Thanks very much Jon, you are very good
Absolute ledgend, i'm currently studying online and they have privided us with the slideshows of the lesson but no one to present them, actual explanations help immensely, Thank You!
I'd been struggling for so long until I found this video. You're a life saver! Thanks!
I know I've commented this video before, but again, thank you so much for your Excel videos! Your work has been a significant help to me. Thank you so much!!!!!
By minute 4 I learned 3 different shortcuts that I have never heard of before. Super clear presentation, awesome video. Thank you.
That's so funny, same here (I knew F4 but always forget about it)
There's a lot of INDEX MATCH videos on YT but this one is one of the best.
Thank you, James! :)
I've never heard of INDEX MATCH formula, until recently. But only with your video I can understand how to use it and write formula correctly! you explained it very clearly and easy to understand. Thank you very much!! I appreciate your generosity sharing these knowledge. Thank you for sharing the Excel file as well. I have liked and Subs as well.
You saved my life. I had the hardest time trying to figure it out before. Thanks
This is the only video where I understood how to use index + match instead VLOOKUP. Thank you sooooo much 🤩
This is such a great tutorial on INDEX MATCH. I love that this broke down each function's definition and even put the requirements in layman's term for anyone without coding experience. The snippet about using data validation for pulling up values was brilliant. Definitely is another great idea for my toolbox. Thank you for the awesome, well-articulated video.
As someone named Lehman I really appreciated the video.
This isn't really coding.
Hi Jon, I'm taking an intro to accounting spreadsheets course online, and it has been kicking my butt. We only have one video lecture a week and it is about 20 minutes, and doesn't nearly explain the information like you do. Thank you for taking the time to create these videos for us, it has already taught me a lot and made these nested functions make sense. :)
Thanks for the feedback, Anna! 😀
Finally I get to understand Index and Match after a long struggle. Thank you so much.
I spent an hour googling and I only watched your video for 2 mins and fixed the problem ✨🎉 THANK YOU
Perfect!!!! Perfect!!!! Perfect!!! I was struggling with finding the perfect document to work with, and this INDEX/MATCH UA-cam video appeared.I am now able to understand this content very clearly, now I know that my students will also feel confident once I share the INDEX/MATCH examples with them.
Hi Karen!
You liked the video?
I can’t thank you enough this has helped me analyse quickly thousands of rows of data in multiple sheets. Subscriber gained.
LOVED THE CONTENT AND YOU EXPLAINATION ALOT, ONE MORE THING I HAVE NOTICED IS THE WAY YOU ARRANGE THE THOUGHTS TO INSTALL THE FORMULATS CORRECTLY IN OUR MINDS THANKS ALOT
Thanks for the feedback! 😀
Once of the best tutorial I have ever seen on Excel. Great!!!!!!!!!!
i literally solved my excel / google sheet dilemma with the help of this tutorial! index + match! such a big help. thank you Jon for your demonstration, will surely watch your other videos! God bless you.
Was having issues with getting VLookup to work, and this option for Index/Match was perfect! Using it to create a table to calculate price for leather goods--and using a table with leather name & price and putting into a formula to calculate cost for each item configuration (up to 6 pieces and 6 types of leather per an item...).
VERY WELL done video! I must admit, the INDEX/MATCH was confusing me at first, but this video helped clear up everything! 5-stars!
You are the best person to explain this. with simple and clear example. Much much appreciated!!1
I appreciate that! 😀
Very professional and well created/produced. The circling of the array or individual cell is a nice effect and visual. Compared to some "how to" videos where the person records themselves on a cell phone this is top notch.
Thanks, Jim! :)
Its the best explanation i have come around so far
This tutorial was incredible! full of easy examples, common errors and how to fix/prevent them. I'm subscribing right away. Thank you!!
Awesome, thank you Magnolia!😀
best and easy to grasp explanation I have ever came across. Thank you very much!
This is the best video to understand Index and Match. Thank you !
You know how to explain Brother thanks.....will recommend this video to alot of people
Thank you so much! Your video was really helpful. I can't believe i just learned how to use index and match in under 20 mins!
Much appreciated - I used to utilize Index/Match frequently, but it had been a while and I was making a mistake (forgot to anchor...). This explanation/tutorial is waaaayyyyy better than whatever I read/watched several years back, you're a rockstar.
Hi Jon!!!
One grateful new subscriber here 😊. I have been looking on how to use this same formula so I have watched multiple videos here in youtube and you are the only one who helped me the most in understanding how this function works . Please do not stop making videos like this because you are one of a kind when it comes to making the viewer understand what they wanted to know . Thanks and have a great day !
since I started following you, Jon. I have become the best instructor thank you for your training technics Jon.
Finally some you can understand, great work mate
This video changed my life.
a very good tutorial on index match . i found other youtube tutorials convoluted and confusing . Great job thanks
Bullseye, Simple, Crisp, TothePoint. You Rock Jon - keep up the good work
Thank you so much for your explanation. Your class is the best! I want to follow all of your sessions.
Thanks Sir ... time and again I watch this Video as Dictionary for my Index and Match solutions... Thanks again Sir
Where have you been all this time. This is amazing 👏
Thank you
You're welcome, Islam! 😀
Excellent presentations, short, crisp and to the point.
Ive been looking for this for so long.. thank you very much
Good video. Was having trouble understanding the function after reading a bunch of different sites but was able to use index match after watching the video. Thanks!
Thank you so much! This video solved the problem that I have been working on for 2 days toggling with vlookup function . Silly me. Very helpful and easy to follow.
Thank you so much! I couldn't figure it out from all of the other tutorials but your tutorial made something click in my brain.
Thanks for explaining such a complex function in a simple way.
Thank you so much for delivering a clear and well paced explanation of these functions. One of the best videos of this nature I've seen.
Glad you liked it! 👍
Thank you so much!!!! Your explanation is very neat and clear !
This is one of the best explanation so far
The best explanation from among hundreds of Excel Masters.... I just love the way you explained... It was awesome... I just subscribed and also refer many of my friends..... Great Work - Jon..... Wonderful... Keep it up.....
Thank you for this. Great video to follow along. Helped me with my issue of pulling the data of only a few countries out of a global list. Much appreciated!
Glad it helped! 😀
Great video! I have always used VLOOKUP and have implemented work-arounds for looking left or whatever. You have prompted me to revisit INDEX-MATCH. Thanks!
I've watched several tutorials before this one and couldn't understand how this works. The cheat sheet helped a lot. This is the best tutorial I came across and managed to make my formula work. Thanks, Jon!
Thanks for this video! I've never used INDEX/MATCH but will defintely give it a try.
Bless you! You explain it so well - thoroughly and slowly. Thank you!
You're welcome, Busola! 😀
Jon I love your teaching style, mentioning all the hotkey shortcuts and going through each portion of functions along with a file to follow along. Perfect!!!
Perfect ! It can not be better the way you have explained. Thank you !
This video was so well explained!! Clear and concise. Excellent! Thank you!!
TY, TY, TY. I'v been trying to wean myself off V & H lookups but I'm having the hardest time grasping how Index Match works. Your video was extremely methodical and easy to comprehend. 🤞🤞🤞Let me go try it
Bro your simple definitions help so much!!!
Thanks so much! 😊
This is the best tutorial I have come across today, Thank you so much
Happy to hear that! 😀
Omg, thank you so much 🙏. Never understood something complex so easily before.
Well explained John, looked at so many well presented and well explained. I will be your number one follower.
Your tutorials are invaluable resource for me. You are doing such an amazing job!! Thank you for bringing up such good content.
Watched the video, You did a great job of explaining the Index/Match vs VLookUp. Very simple to follow and added to my list of videos.
Awesome, thank you for the feedback! 😇
You're an awesome instructor - I am grasping your tutorials more than I have others. Thank you!
Very good detail and your Error sheet notes were very good Thank you for your work
Thanks! I appreciate the nice feedback. 🙂
You explained index & match in a concise and easy to understand way. Thank you trillions!
Love how you explain your videos, You really have a genuine passion for this! Big thank you
Thanks and very much thanks for the video. It is the best simple, brief training that has made me understand and prefer index match over vlookup
So informative. Love this... Keep the tutorials coming. Thanks