MS Excel: How to combine Match and Index to create a powerful lookup formula

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.