31 October 2015
The function combination OFFSET MATCH MATCH can be useful for looking up values in a two dimensional array of data. The primary benefit of using OFFSET MATCH MATCH is that it is intuitive and that many people are familiar with the OFFSET formula.
In some ways, using the OFFSET function to find a lookup value is more intuitive than using the INDEX function because it is very similar to moving a piece around a chess board.
Additionally, some people are more familiar with the OFFSET function than they are with INDEX; in that situation, it may make sense to go with OFFSET MATCH MATCH as your lookup formula.
Full article: How to use OFFSET MATCH MATCH
