Description
This function returns the position (Row OR Column Number) of a value. This is opposite to the INDEX function, where value is returned based on its position.
The MATCH function makes a powerful combination when used as input in the INDEX function. This nested function of INDEX & MATCH is an effective alternative for the limitations of VLOOKUP and HLOOKUP functions.
=MATCH(lookup_value,lookup_array,match_type)
The MATCH function’s syntax has the following arguments:
- lookup_value Required
The value which we want to match in the lookup_array.
The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.
- lookup_array Required.
The range of cells being looked for.
- match_type Optional.
The number -1, 0, or 1.
The match_type argument is to indicate how Excel matches lookup_value with values in lookup_array.
The default value for this argument is 1.
