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
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