ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How can we use match function in excel formulas ?

user-image
تم إضافة السؤال من قبل Mohamed Abou Ghanem , Accounting Manager , Al Mabani International Real Estate
تاريخ النشر: 2017/02/02
Mohamed Shaheen
من قبل 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
من قبل 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

المزيد من الأسئلة المماثلة