The Match Function !

This function looks for an item in a list and shows its position. It can be used with text and numbers.

It can look for an exact match or an approximate match.

Syntax is

=MATCH(lookup_value, lookup_array, [match_type])

Meaning

=MATCH(WhatToLookFor,WhereToLook,TypeOfMatch)

The TypeOfMatch either 0, 1 or -1.

Using 0 will look for an exact match. If no match is found the #NA error will be shown.

Using 1 will look for an exact match, or the next lowest number if no exact match exists.

   If there is no match or next lowest number the error #NA is shown.
   The list of values being examined must be sorted for this to work correctly.

Using -1 will look for an exact match, or the next highest number if no exact match exists.

   If there is no exact match or next highest number the error #NA is shown.

   The list must be sorted for this to work properly.

I hope you find this function helpful,

Keep visiting for more knowledge on excel.

Cheers !