Excel defines match funciton as "Returns the releative position of an item in an array that matches a specified value in a specified order". In simle plain language Match function searches for a value in a defined rane and then returns its position.
Syntax
Match(lookup_value, range, match_type)
'lookup_value' signifies the value to be searched in the array.
'range' is the array of values on which you want to perform a match.
'match_type' Match type is an important thing. It can have three values1,0 or -1
Example
If you apply Match_type = 1
This means that Match searches the whole range for the value 104 but as 104 was not present in the list so it pointed to the relative position of a value slightly less than 104 i.e 103.
If we apply Match_type = 0
Then it will result into as error as "0" signifies excel match and a absence of the value 104 the function will give an error #N/A
If we apply Match_type = -1, the result is 4
This is because as the value 104 is not present in the array so the Match function points to the relative reference of value slightly greater than 104 i.e. 105
Syntax
Match(lookup_value, range, match_type)
'lookup_value' signifies the value to be searched in the array.
'range' is the array of values on which you want to perform a match.
'match_type' Match type is an important thing. It can have three values1,0 or -1
Example
If you apply Match_type = 1
This means that Match searches the whole range for the value 104 but as 104 was not present in the list so it pointed to the relative position of a value slightly less than 104 i.e 103.
If we apply Match_type = 0
Then it will result into as error as "0" signifies excel match and a absence of the value 104 the function will give an error #N/A
If we apply Match_type = -1, the result is 4
This is because as the value 104 is not present in the array so the Match function points to the relative reference of value slightly greater than 104 i.e. 105
0 comments:
Post a Comment