MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching. MATCH is often combined with the INDEX function to retrieve a value at a 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] 1 = exact or next smallest (default), 0 = exact match, -1 = exact or next largest.
In the example the MATCH FUNCTION is used to fetch the position of the searched value in the table. Here the 3rd argument is set to "0" for exact match.
Note here the function is not case sensitive. Also please note that the table contains repeated values. The MATCH function brings out the first occurence of matching.
0 comments:
Post a Comment
If you have any queries, please let me know.