MATCH

Gives the relative position of specified value in an array instead of value itself

Syntax of EXCEL Match formula:
=MATCH(lookup_value,lookup_array,[match_type])

In words:
=Match and give position(of this value, in this range, [with this matching type])

Examples

excel match example

In the above situation to find the value of product HH we will use the following formula:

=MATCH(“hh”,A3:A13) and it will return 8

One thing to note is that MATCH function does not distinguish between lowercase and uppercase text.

Also the position of the item is evaluated with reference to range and not the worksheet. HH is at the row 10 however, the result was 8 because our range starts from row 3.