The ULTIMATE Index Match Tutorial (5 Real-World Examples)

Learn the Index Match function in Excel to look for any value in a dataset

In this video you'll learn all about the index match function using five real-world scenarios you might encounter at work. First, we'll go over a simple index match with one criteria. Then, we'll go over an index match with two criteria, meaning we'll need two match functions (one for the row and one for the column). Third, we'll go over a dynamic index match where we'll use relative referencing to apply the same function across multiple ranges. Fourth, we'll go through an advanced index match example with three criteria by combining the index match with the ampersand. Finally, we'll go over the main limitation of the index match with an alternate solution using the SUM and FILTER combinations.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Simple Index Match
1:44​ - Index Match with Two Criteria
3:31​ - Dynamic Index Match
6:57​ - Advanced Index Match
9:05​ - Bonus Function

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

[stevenchappuis]

The most understandable explanations of EXCEL formula use on YouTube. Thanks Kenji!

[tommyluu]

I have a job interview coming up, you got the best Excel content on Youtube man keep it up! Videos are straight to the point and useful.

[BockarieTNgegba]

Good morning, Sir. Thank you for your hard work. I personally have learned a lot from your videos on YouTube here. It's 2:14 AM here in Sierra Leone local time. I Strongly want to become a Business data Analyst.
Once again thank you very much and God Bless you

[chatureshpatel]

Just got myself into more advanced Excel and this is amazing, easy to understand and full of tips that are usefull, perfect....

[gurpreetkaur]

I watched multiple videos on Youtube for however, your video was super simple and well-explained. Thank you so much for creating such videos and educating us.

[santiagozapata]

In the Bonus, can we use another formula such as Sumifs instead of using filter??

[sabpebhari]

For the last function instead of using filter function twice we could also use * as AND operator

[Moiez]

bro, you explain the best so far! It really helped with the examples of countries, months, and salaries!

[gerbherb]

Nicely done! One question: why are you not using XMATCH?

[KS-jbjk]

Appreciate the clear explanation from you, Kenji

[wendycanfield]

Thanks so much Kenji! I watched few other people's videos but still didn't get. You made it easy to understand !

[levyfreitas]

I'm brazilian and this video is AMAZING, the "Advanced Index" help me a lot!! Bro you explain the best so far! Thanks Kenji.

[milanpatel]

For the last 5. Bonus spreadsheet, a simple SUMIF also does the trick!
=SUMIF(B10:B28, C3, C10:C28)

[NihilPraveen]

I was mind blown by the bonus tip at the end. Great explanation of excel functions

[Leadership-]

I know people, you are a bit different. I don't know exactly how but It appears everything is clear for me. thank you so much,

[flightforge]

hi kenji..your from where? thanks for this index match tutorials.

[nazuada]

Thank you, this was very helpful. I am still a little confused about the $ to fix columns and rows, but other than that I was able to create my little project :)

[Ruphan]

Hi Kenji, do you know how to use the index match formula with 2 arguments but when 1 argument is that the reference cell needs to contain words from the array, but the reference cell can contain those words and other words as well?

[thediscrete]

Great tutorial, very simple and easy to follow.
One small comment for the bonus example, I believe a “sumproduct” function with 3 conditions will be a better option to use

[TVSCDN]

Thanks for your wonderful explanation..just a suggestion...MATCH is not pronounced as MUCH😊🎉🎉🎉❤❤❤