Excel FunctionsExcel MATCH Function

Using Match function


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.



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.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.