Match:
Supposedly one is in a real hurry ( i think this needs not to be "supposed" as we have already been made to swallow that time = money), one needs to find the relative position of specific item in a speific range in excel.
In such cases, Match comes into play which is pretty self - explanatory and easy to understand.
The syntax and its description is given below -
lookup_value - is the specific item one is looking for
lookup_array - the specific range of excel
[match_type] - which is optional and gives the value as per type selected which can be either exact match or an appoximate match.
Supposedly one is in a real hurry ( i think this needs not to be "supposed" as we have already been made to swallow that time = money), one needs to find the relative position of specific item in a speific range in excel.
In such cases, Match comes into play which is pretty self - explanatory and easy to understand.
The syntax and its description is given below -
lookup_value - is the specific item one is looking for
lookup_array - the specific range of excel
[match_type] - which is optional and gives the value as per type selected which can be either exact match or an appoximate match.
0 comments:
Post a Comment