Explanation

This formula is a standard version of INDEX + MATCH with a small twist.

Without the third argument, match_type, defined, MATCH defaults to approximate match and returns 2. you’re able to use INDEX to retrieve individual values, or entire rows and columns.

MATCH supports approximate and exact matching, andwildcards(* ?)

Excel formula: Next largest match with the MATCH function

Often, MATCH is combined with the…

Excel formula: INDEX and MATCH approximate match

Excel INDEX function

Excel MATCH function