4 Mins. to MASTER Excel INDEX & MATCH formulas!

Overcome the limitations of VLOOKUP. Get up to speed with Excel INDEX & MATCH formulas fast. We'll look at the functions individually and then bring them together to perform powerful lookups using real world examples.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍

💬 Please leave me a COMMENT. I read them all!

🧟‍♀️ CONNECT with Mynda:

⏲ TIMESTAMPS
0:00 How to write INDEX & MATCH Formulas
0:31 INDEX Formulas
1:11 MATCH Formulas
1:47 INDEX & MATCH Formulas
3:09 Lookup to the left

[lww]

This is the best video explaining how INDEX and MATCH work together. Thank you so much for sharing!

[furtadorebeca]

Thanks for the video. Your explanation is super clear making it easy to follow and understand. I love how short videos like this serve the purpose of explaining the concept with no time-wasters. Cheers.

[voiceofsoul]

Bravo!, You helped me a lot in learning Excel formulas. Hats off to you! You are such a nice teacher. Thank you.

[hansgulbranson]

This is the best Index/Match tutorial on YouTube. None of the other videos made sense, and this one was short. Thank you!

[Brownbeardad]

Your Excel training videos are best on Youtube. Your instructions are easy to follow and understand, and presented professionally. This video provided me with the information needed to determine my application required the match function combined with offset function. I watched other training videos until I came across your channel. I have subscribed and will go to your channel for future training. Thanks.

[NihonDream]

The best explanation ever. Thank you Mynda!

[thinkleclt]

Mynda, always love the content ( this is Tom hinkle ) on this one I want to offer another perspective.

None of what you say about index-match is wrong, but….

In my experience, many times I help business user create spreadsheets and mini models.
I have found that many basic users get more confused with index/ match than vlookup. Also, index match functions can get big and confusing FAST. So I was mostly team vlookup.

Now probably the biggest limitation to vlookup is that your key field had to be the leftmost column. For me, the way I structured tables and queries, that was always the case anyway. There were time where it didn’t work though.

And 1000%. Team XLookup all the way now. Best of both worlds

[IvanCortinas_ES]

Direct and clear, as always. Thank you Mynda.

[SergioAlejandroCampos]

I some cases, INDEX MATCH is better than even XLOOKUP. Thanks Mynda.

[gospelmoto]

Awesome! thanks for sharing. I'm a regular watcher of your videos. You are getting lovelier and lovelier each time.

[vusalaclifton]

Thank you . simple and clear explanation

[Bimbolalaoshe]

You've gained a follower today ❤❤, Explains my question “How do I get the row & column number of a content in between Thousands of data?” Thanks for explaining better than videos I've watched.

[VP-ypip]

Very helpful. I much appreciate this video.

[ivicai]

mind-expanding! thank you so much Mynda for your effort with this channel... you make complicated stuff so much easier to work with!! 💚

[anillpatel]

This is just what I was looking for.
So well explained.
Thanks Mynda.

[souptonuts]

Must be laundry day at Mynda's house. No green shirt!

[teoxengineer]

Hi Mynda,
Beside, There is an another good usage of index to navigate areas which you want to select correct range of data

[TheShimming]

Thank you very much for the useful tutorial.

[devinlewis]

Awesome videos! How do you know when you need to use absolute reference? What is the difference?

[MrDhunpagla]

Thank you for sharing 😊 You are awesome 👍