Dynamic period

The goal of the exercise is to use the versatile combination of OFFSET(), INDEX() and MATCH() functions.

Can we leverage OFFSET() function to make our worksheets more dynamic? Suppose you'd like to enable your colleagues, who will be using this sheet, to quickly calculate values based on their selections. We will learn how to do it in this exercise.

For your convenience, we provide the syntax of OFFSET() and this of INDEX() and MATCH() functions: