4 things you should know about MATCH functionĪs you have just seen, using MATCH in Excel is easy. But because the scores are sorted from largest to smallest, it also tells us that Laura has the 5 th best score among all students. Technically, the Match formula returns the relative position of Laura in the range. Optionally, you can put the lookup value in some cell (E1 in this example) and reference that cell in your Excel Match formula:Īs you see in the screenshot above, the student names are entered in an arbitrary order, and therefore we set the match_type argument to 0 (exact match), because only this match type does not require sorting values in the lookup array. To find out where a specific student (say, Laura) stands among others, use this simple formula: To better understand the MATCH function, let's make a simple formula based on this data: students names in column A and their exam scores in column B, sorted from largest to smallest. The lookup array should be sorted in descending order, from largest to smallest or from Z to A.
1 or omitted (default) - find the largest value in the lookup array that is less than or equal to the lookup value.The match_type argument set to 0 returns only the exact match, while the other two types allow for approximate match. Match_type (optional) - defines the match type. Lookup_array (required) - the range of cells to search in. It can be a numeric, text or logical value as well as a cell reference. Lookup_value (required) - the value you want to find.
0 kommentar(er)
