Lookup and Reference
MATCH function searches for the specified lookup_value in a range or array then returns the relative location of that lookup_value in the range or array. It will always give us a number. This function is commonly used with INDEX function to give us a result same with VLOOKUP and HLOOKUP. MATCH can also be used with VLOOKUP and HLOOKUP through the 3rd argument, (column or row index number).
=MATCH(lookup_value, lookup_array, [match_type])
lookup_value - This is the data that excel will lookup into the range or array. It may be an alphanumeric, numbers, or a function. There should only be 1 data / cell of lookup value per MATCH.
lookup_array - This is the range or array that excel will lookup into. It should contain the lookup_value.
[match_type] - This specifies how it will match the lookup_value in the lookup_array. Input here can -1, 0, or 1. This is an optional argument. When this argument is omitted, the default input here is 1.
MATCH can be a useful tool for working with data in Excel and Google Sheets, particularly when you want to find the relative position of a value within a list. It can be used in combination with other functions, such as INDEX, to return a value based on the position returned by MATCH.
You have a list of product names and you want to find the position of a specific product within that list.
You can use MATCH to search for the product name and return the position of that product within the list.
Still need help with Excel and Google Sheets?
Get Instant Expert Help in Fiverr
Get Instant Expert Help in PeoplePerHour
We can also accept LEO, HIVE, HBD tokens as payment.
This post is designated as a reviewer for Excel trainings I conduct.
Feel free to share with anyone. 馃槈
Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva.
