Excel INDEX / MATCH Function for an Advanced Lookup

In this video, we explain how to use the INDEX and MATCH function in Excel for an advanced lookup formula instead of VLOOKUP.

The VLOOKUP function is awesome but has its limitations.

This video discusses some of the limits to VLOOKUP and shows two examples of the INDEX and MATCH function combination overcoming them.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[willisjwhhbjrjrb]

After watching countless of videos and searching all over and reading articles, the logic only made sense with your wording. Thank you.

[iheartbunnies]

I haven't commented on any videos for so long but just wanna say tysm sir u saved me a lot of trouble and ur a real g

[anelimrimo]

I'm taking an excel class and I didn't understand my teacher, but I understand you. Thanks so much.

[saifalislam]

Have been watching some other videos on this topic, but this video explained it so well, Thanks!

[keithtomalin]

Great Video... Sooo much better than Vlookup. Well done and thank you.

[nnbnn]

Thank you so much for your help!Really detailed and well explained!

[KaldaneAnswers]

Nice Video. I always like the way you explain things

[ihormaza]

Thank you for your detailed and clear explanation. It was very helpful!

[etpollylifts]

God bless you. Thank you for this tutorial you saved me

[SivadasKRamdas]

Thanks Buddy, this video helped me a lot to solve one excel problem i was facing.

[arifurrahman]

Sir, Thank you so much for your most useful tutorial.

[lucmorineau]

Excellent video and explanation, thank you so much! I made some update to your proposal to use tables, also working well :)

[angelkz]

Thank you! Just what I've been looking for!

[kvlpnd]

2:50, " I don't wanna hurt its feelings " 😂😂

[posfr]

For years I resisted Excel Tables instead of old-school ranges and INDEX-MATCH instead of VLOOKUP. Now, having used Power Query, I'm totally converted - born again. With Tables, and using "structured references", the MATCH and INDEX functions write themselves and become self documenting. If you convert your range to a Table and name the table COURSES, the first of your formulas becomes something like =INDEX(COURSES[Company], MATCH(4202, COURSES[Course ID], 0))

[youlilgremlinkun]

Thank you for the video! One question: Is there a benefit to a two-way lookup function? When you brought it up, I wasn't clear on why it was beneficial to have a Match for the column. I was thinking in my head "Why wouldn't we do what we did earlier and select the specific column as the table array?"

I feel like I'm missing out on how it can be useful in some scenarios, so if anyone has an answer, I'd appreciate it! Thanks again for the video, much appreciated for the help!

[miguelgaitan]

Hello, I'm very interested in taking a course in Xlookup, indexmatch, formulas

[mightyhunter]

Thumb Up sir .
my question is : how did you convert match formula in row number? on the time 9:55
plz reply

[mrbuthelezi]

i have been struggling with this function for a while, the n i watched this video and attempted the problem i had at work once. never been this happy in a long time
Thanks man
☺•o☺♂♂o♂♂

[artlogo]

Is there a search button that can produce 3 results, A button you press ?