Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How can we use match function in excel formulas ?

user-image
Question ajoutée par Mohamed Abou Ghanem , Accounting Manager , Al Mabani International Real Estate
Date de publication: 2017/02/02
Mohamed Shaheen
par Mohamed Shaheen , Business Analyst , GreyOrange Robotics

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.

Syntax: 

=MATCH (lookup_value, lookup_array, [match_type])

Arguments: 

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.

Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

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

More Questions Like This