Exceljet

Quick, clean, and to the point

Excel tips: index-match

These videos come from our accelerated video training.
Tip: How to do a two-way lookup with INDEX and MATCH
In this video, we use use MATCH to find the position of an item in a table, and we use INDEX to retrieve the value at that position. We work step-by-step so you can see how both functions...
Run time: 3:17
Tip: How to look things up with INDEX
In this video, we look at how to configure INDEX to fetch a value by row and column. This is half of the INDEX/MATCH equation.
Run time: 2:48
Tip: How to use the MATCH Function for exact matches
In this video, we look at how the MATCH function can find the position of an item in a list. Once you have a position, you can use it to get related values with INDEX.
Run time: 3:23