A two-function lookup combo that finds a row with MATCH and returns a value with INDEX.
Try it with AIINDEX/MATCH is a flexible alternative to VLOOKUP: MATCH finds the position of a value, INDEX returns the cell at that position. Unlike VLOOKUP it can look left and doesn't break when columns are inserted.
=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))On large sheets it can be, and it's more robust to column changes. XLOOKUP now covers most cases.