Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Use the MATCH function to get the relative position of an item in an array. Match offers several different matching modes, which makes it more flexible than other lookup functions. Used together with INDEX, MATCH can retrieve the value at the matched position.
=MATCH (lookup_value, lookup_array, [match_type])
lookup_value - The value to match in lookup_array.
lookup_array - A range of cells or an array reference.
match_type - [optional] How to match, specified as -1, 0, or 1. Default is 1.
we use Match() to check if there is a match in a given range for specific value.
for example, you can check if "Item1" is exist in range.
but we can use it power when used with other function like Index()
Regards