MATCH Function in Excel.
MATCH Function in excel
In this video tutorial, we will learn how to use MATCH Function in excel using MATCH Formula.
Excel MATCH function can be used to find out the relative position of a lookup value in a given range of cells. It returns the position occupied by the lookup value (position would be a numeric value/number) in that given range.
-------------------------------------------------------------------------------------------------------------------
Syntax of MATCH Formula in Excel:
=MATCH
=MATCH (lookup_value, lookup_array, [match_type])
-------------------------------------------------------------------------------------------------------------
Arguments:
lookup_value = The value whose position we wanted to find. It can be a Text, number, logical value, or cell reference.
lookup_array = An array or range of cells under which we wanted to find out the relative position of lookup_value.
match_type = An optional argument that defines the logic behind matching. How the match will happen. Takes arguments as -1, 0, or 1.
If match_type = -1, it means that the MATCH function will find out the smallest value, which is greater than or equal to the lookup_value. For this to happen, the lookup_array must be sorted in descending order.
If match_type = 0, it means that the MATCH function will find out the value, which is exactly the same as that of the lookup_value.
If match_type = +1, it means that the MATCH function will find out the largest value, which is lesser than or equal to the lookup_value. For this to happen, the lookup_array must be sorted in ascending order. The default value for the match type is +1.
-----------------------------------------------------------------------------------------------------------------------
To know more about the MATCH Function in Excel, you can go to this link:
https://www.educba.com/match-in-excel/
https://www.educba.com/match-function...
-------------------------------------------------------------------------------------------
Connect with us!
Youtube ► / @educba_official
LinkedIn ► / admin
Facebook ► / educba.official
Instagram ►https://www.instagram.com/educba.offi...