# INDEX and MATCH: application of the two functions separately and combined

Feel free to download our Exercise file and practice along with the video. And don’t worry, there is also a Solution file with all the formulas.
We have more explainers on advanced Excel functions you might be interested in – VLOOKUP and MATCH; VLOOKUP COLUMN and ROW; INDIRECT, VLOOKUP and INDIRECT.
In this extract we will see two interesting Excel functions: INDEX and MATCH. We’ll show them within the same video because they are often applied together. Their combination offers an interesting alternative to VLOOKUP. Let’s see the application of the two functions separately and then combined.

## Add comment