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

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

متابعة

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

Salam Waddah
من قبل Salam Waddah , Staff Software Engineer , Hello Chef

Match function is simple of its own but very powerful if you combined it with another function like Index.

Using Index + Match functions together will help you find a piece of info in a large dataset and it's not easy to show how with text. Try YouTube it's very helpful just type "Index Match Excel"

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