Two-way lookup with INDEX and MATCH
In this example, the goal is to perform a two-way lookup, sometimes called a matrix lookup. This means we need to create a match on both rows and columns and return the value at the intersection of this two-way match
The core of this formula is INDEX, which is simply retrieving...Read more
