INDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618)

Learn all about the Excel INDEX & MATCH Lookup Functions is 10 minutes. Here is the list of topics in this video and the time hyperlinks that the specific section of the video:
1. (00:30) Introduction to what INDEX and MATCH can do
2. (01:42) All about MATCH Function
3. (02:04) MATCH for Exact Match Lookup, [match_type] = 0
4. (02:34) What is Approximate Match?
5. (03:16) MATCH for Approximate Match Lookup with values Sorted Ascending, [match_type] = 1 or omitted
6. (04:02) MATCH for Approximate Match Lookup with values Sorted Descending, [match_type] = - 1
7. (04:17) INDEX and MATCH together to do any type of lookup
8. (04:26) INDEX & MATCH to do One-way lookup to retrieve a single value in a column to the left of the lookup value. Example of Exact Match Lookup.
9. (05:34) INDEX & MATCH to do One-way lookup to retrieve a single value in a column to the left of the lookup value when lookup values are sorted biggest to smallest. Example of one type of Approximate Match Lookup.
10. (06:17) INDEX & MATCH to do Two-way lookup to retrieve a single value. See second type of Approximate Match Lookup and an Exact Match Lookup.
11. (07:24) How to Copy Two-way lookup formula.
12. (09:01) INDEX & MATCH to lookup a list of values
13. (09:23) INDEX & MATCH to do Two-way lookup to retrieve a full row
14. (10:15) INDEX & MATCH to do Two-way lookup to retrieve a full column
15. (10:41) INDEX & MATCH to do Lookup an item from multiple tables
16. (10:41) MATCH to get Table Number
17. (11:11) INDEX & MATCH to do Lookup Columns Headers
18. (11:56) Summary

[excelisfun]

Topics:
1. (00:30) Introduction to what INDEX and MATCH can do
2. (01:42) All about MATCH Function
3. (02:04) MATCH for Exact Match Lookup, [match_type] = 0
4. (02:34) What is Approximate Match?
5. (03:16) MATCH for Approximate Match Lookup with values Sorted Ascending, [match_type] = 1 or omitted
6. (04:02) MATCH for Approximate Match Lookup with values Sorted Descending, [match_type] = - 1
7. (04:17) INDEX and MATCH together to do any type of lookup
8. (04:26) INDEX & MATCH to do One-way lookup to retrieve a single value in a column to the left of the lookup value. Example of Exact Match Lookup.
9. (05:34) INDEX & MATCH to do One-way lookup to retrieve a single value in a column to the left of the lookup value when lookup values are sorted biggest to smallest. Example of one type of Approximate Match Lookup.
10. (06:17) INDEX & MATCH to do Two-way lookup to retrieve a single value. See second type of Approximate Match Lookup and an Exact Match Lookup.
11. (07:24) How to Copy Two-way lookup formula.
12. (09:01) INDEX & MATCH to lookup a list of values
13. (09:23) INDEX & MATCH to do Two-way lookup to retrieve a full row
14. (10:15) INDEX & MATCH to do Two-way lookup to retrieve a full column
15. (10:41) INDEX & MATCH to do Lookup an item from multiple tables
16. (10:41) MATCH to get Table Number
17. (11:11) INDEX & MATCH to do Lookup Columns Headers
18. (11:56) Summary

[GeertDelmulle]

WOW! Your Storytelling is like perfect! Truly “audiovisual”: your visuals speak every word you say, and perfectly synchronized, too!
BTW, coincidentally: this was the perfect synopsis video on INDEX & MATCH! The best one I’ve ever seen!
Thanks a lot!

[desm]

I love it that you have pinned a topics summary on the comments. Thank you.

[wayneedmondson]

Hi Mike.. as usual.. even your quickie videos are overflowing with EXCEL goodness and value. Whether by way of review or a fresh topic, I always learn something new by watching you work. Even with more functions on the way from Microsoft, understanding the fundamentals of INDEX and MATCH is key to EXCEL mastery. Thanks for the quick lesson and for the links to the Full Story videos which I look forward to studying in depth. Double Thumbs up for always outdoing yourself to the benefit of the community!!

[DougHExcel]

Short and sweet set of examples using the INDEX/MATCH functions...thanks Mike!

[NoShadowOfDoubt]

My two friends at work.... Index and match!....Thank you

[andrewjohnson]

These videos on “simple” topics are packed with info. Thx👍

[nicholaslynn]

I went through your complete Excel Basics course during the last few weeks. I am prepping to take the MO-201 test and this was a skill that I found I understood the concept of, but did not know how to actually write the formula out. What a great refresher. I definitely won't be missing any Index and Match questions on the exam. Thank you!

[chavelooo]

Thank you, Thank you and Thank you. I have memorized this video and thanks to the info and the excercices I approved my Technical test and got a new job. Thank you very much for your help support and effort doing this channel.

[houstonsam]

Crystal clear and spot on for relevance, as usual. You are the rock star of Excel.

[stevennye]

Excellent review, great video that refreshes and reinforces previous learning for people who don't use this formulas everyday.

[khalidrehman]

Hi Mike,
Another Great video, you've covered all in one.
Love to learn from you.

[laviedandre]

Great idea for a series. Love your comprehensive videos, don't get me wrong, I've learned so much from those videos and workbooks. But for a refresher, or to point a colleague to summary on an Excel topic, these will be my go-to. Thanks Mike!

[chachi]

I was researching how to do Index & Match functions today and I can't believe I just applied it on a file I was working on thanks to this video. You are amazing. Thank you so much!

[beautyjournal]

Omgggg I missed this video and you dedicated to me !!! Thank you so much for your explanation and your dedication! Your viewers appreciate you very much for sharing your knowledge!

[deninsrmic]

Brilliantly explained Mike witting all the details about =INDEX(MATCH() lookup function necessary to understand from your Excel Knowledge-Box. Your last example in this tutorial I remember you expounded on in a long video tutorial of yours where the whole platoon of pertinent details came down on me charging with attempt to incite ones interest in exercising it. This tutorial however it’s much shorter but comprises succinctly all one needs to know and refreshes ones learned skills. Great job as always. Thanks.

[ogwalfrancis]

index and match, great combination, thanks

[zt.]

Excellent. Truth is your presentation and teaching skills are also very good (in addition to being the Excel magician); one day you should have a video on producing an education video because you are way better than anyone I have seen in online education. Thanks for all the hard work!

[msifre]

You have not idea, how I appreciate all your help. Thank you so much

[jinasalcedo]

Thank you again! I was confuse on multiple index match conditions. I understand it better after watching your video . Great teacher!