In the latest episode of our Excel how-to series, we show you how to use Excel’s Index and Match functions in combination for financial models. 

In this example, we have a number of different inflation scenarios that could be applicable. Discover how to select the correct one using the Index and Match functions.

 We also show you some of the best practices to adhere to when inputting your formula.