MATCH
Returns the position of a value within a range, as a number: MATCH(lookup_value, lookup_array, [match_type]). It is the half of INDEX and MATCH that finds the row or column, and it returns only the first match.
When to use
Write 0 as the match type for names and labels, because the default assumes sorted data and can return a wrong row without an error. Use one MATCH for the row and a second for the column to build a two-way lookup.
See Lec 06.