This is really a four part question.
I have read on google the synatx for the match, index, and offset functions and don't still understand why you would use them and in what context.
I also ran across a cell with a formula which contained all three of the functions in one syntax. How do you do that and how is it best used.
If it is possible to provide a few examples that would be helpful. I like to visualize and see what what is going on as I read along.