Register now or log in to join your professional community.
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.
=MATCH (lookup_value, lookup_array, [match_type])
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.
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
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"
