INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works ...

The INDEX formula doesn’t recognize column letters, so you must use numbers (counting from the left). The syntax for the MATCH function is: MATCH (lookup_value, lookup_array, [match_type]).

Write the formula: Use =INDEX(range, MATCH(lookup_value, lookup_range, match_type)) to combine both functions. Practice with examples: Apply the formula to real datasets to understand its ...