MS Excel: Create a dynamic report with Sum, Average, Match and Index

In this video I will show you how to combine the functions Match and Index, to create a powerful lookup function that can return the value of a cell in a table based on vertical and horizontal criteria.