MATCH then returns the position of the match.

VLOOKUP then returns the first name for id 601, which is Adrian.

Generally, this means the lookup value will be the first value in the table.

Excel formula: Get column index in Excel Table

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

Excel VLOOKUP function

Excel MATCH function

Article image