The MATCH function in Excel returns the position of an item within a list or a range of cells.
Say that you have a Price List and want to know in which position a certain item is located within that Price List, then you would use the MATCH function.
Formula Breakdown: MATCH(lookup_value, lookup_array, [match_type])
What it means: MATCH(lookup this value,from this list or range of cells, return me the Exact Match)
NB: The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.