INDEX MATCH Excel Tutorial

In this step-by-step tutorial, learn how to use Index Match in Microsoft Excel to lookup values. We start with how to use the index function. We use the game Battleship as an example to make it easy to understand. The index function returns a value or the reference to a value from within a table or range. Next, we look at how to use the match function. The match function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. We then bring both index and match together to find specific values within an array. We start with a simple example and then we finish with two more advanced examples. We also look at how to set up a simple drop down list to start building an interactive dashboard.

👋 Additional resources

⌚ Timestamps
00:00 Introduction
01:16 Index function
03:31 Match function
05:36 Index & match simple example
08:50 Index & match advanced example 1
11:54 Drop down lists with index match
13:01 Index & match advanced example 2
15:02 Wrap up

📃 Watch related playlists

🚩 Connect with me on social

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

#stratvert

[mymatemartin]

As a trainer myself, it's your ability to cut through so succinctly to the essence of what's happening that impresses me the most about your tutorials. No unnecessary talk, focused only on key concepts and steps and then trusting your audience to either work the rest out for themselves or come back for more when they're ready.

Very very good.

[swastikszn]

Can we all appreciate Kevin's hardwork and dedication?

[sd]

This is a super powerful lookup function. My 1st time learning was from a software engineer at our company, and the correct way to do this formula slips my mind now and again. I really appreciate you taking the time to make this video because it helps so much when using large datasets for research and analytics. This combined with a drop-down menu is unstoppable. Makes processes so easy and impresses folks as well.

[swastikszn]

I really like the introducuton of Kevin Hi Everyone Kevin Here Today..

[xShapeShifter]

By far the best Index/Match tutorial on YouTube. Thank you so much. I've been stuck on a complex index match formula for hours. I had to go back to the basics to get it right. Thanks again 😉

[gz]

Excel has so many features. It's an amazing powerful program. You explain things with ease. Thank you!

[five_oh_rino]

Kevin thank you for this! You explained a very complex function in such a way that was easy to understand. I've learned so much about Excel from your channel!

[leinad]

The advanced example 2 is EXACTLY what I've been looking for, thanks so much, I've used so many of your tutorials

[SavageGothamChess]

0:42 There is always something special I would like to hear. This time the way you said "Alright" was nice.

[clairestrickland]

Thank you, every time I can't work out how to do something, I find your excellent tutorial and you explain it in a way I can understand.

[parimi]

Hi Kevin,
Yours is the first video I have come across for explaining Index and Match in the most simple manner.
Good job and keep making good videos.

[mjm]

Man you´ve got a gift for explaining - very clear and concise

[mdcs]

Hi Kevin! I use INDEX MATCH all the time but am a long time subscriber and wanted to see your unique take/style on it. I wouldn't have believed you could pack so much useful stuff into 15 mins but you did! Appreciate the early mention about not needing Office 365 as I "complained" about wasting time watching videos only to find late on that my 2019 version wouldn't be any use. I'm an old guy and have struggled to make a living, this being exacerbated by chronic health problems. Excel is one of two skills (the other being languages), that are my stand outs and I really enjoy your videos, so thanks.

[prof.code-dude]

Amazing the best part is that you upload every You are the best!!
Very Useful While Working

[AlexOsborne]

"YOU SUNK MY BATTLESHIP!"

Battleship was a childhood game i enjoyed alot! referencing this with indexmatch was a great way to explain! love it Kevin!

[MrChicago]

Hey Kevin, the way you just broke down index and match was brilliant! I have been trying to figure out how to use it for the longest time but just couldn’t get it until I saw your video. Love your tips and tricks on Excel. Please keep them coming. Thank

[frankfernandez]

You are awesome Kevin! I learned so much from watching your videos. Thank you so much and please keep making videos.

[vramarathnam]

excellent explanation. the greatest part is the simplicity with which you explained it. Thank you Kevin and i will be using this in my next spreadsheet

[thidarwin]

when I saw some Index/ match formula written by others, I was so afraid they are very confusion. you made these complex formula made simple. thanks much!

[rodneynyamutswa]

I thoroughly enjoyed this one. I've had trouble understating indexing and matching. You broke it down nicely