OFFSET double lookup in PowerPivot

One of those really great functions in the native Excel environment is OFFSET. In combination with other functions like MATCH, it can generate a type of 'double lookup' that can be really helpful when creating dynamic reports. For example, the table below describes a matrix defining a coordinate of units for each combination of 'Band' and 'Group'.