Concept: INDEX & MATCH

The traditional robust alternative to VLOOKUP. Combines INDEX(array, row_num) with MATCH(lookup_value, lookup_array, 0) for leftward and dynamic coordinate lookups.