Excel tips: index-match
These videos come from our Excel video training.
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...
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.
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.