The Match function is used to return the relative position of the lookup value in the reference cell in Excel. It has three arguments, the first argument is the LookUp_Value, the second is the LookUp_Array, and the third is the Match_Type; the Match_Type can be set to exact match and...
MATCH函数的使用示例 (Examples of Using the MATCH Function) 示例1:查找数字的位置 (Example 1: Finding the Position of a Number) 假设您有以下数据: 如果您想查找数字30的位置,可以使用以下公式: =MATCH(30, A1:A5, 0) 这个公式将返回3,因为30在范围A1:A5中的第三个位置。 示例2:查找文本的位置 (Ex...
0), MATCH(A15, A5:E5,0))searches for the student name “Alex” in the rangeA5:A12and returns the relative position of that name within the range. In this case, “Alex” is in the third row of the range, so the first MATCH function returns the value3. The third argument of the M...
Use theFill Handleto find other duplicate values in the dataset. Alternatives to the INDEX and the MATCH functions in Excel 1. Use the VLOOKUP Function To extract the price of a product using the column number: SelectB20. Enter the following formula and pressEnter. =VLOOKUP(B20,B6:F17,5)...
Excel HLOOKUP Function. Excel INDEX Function. Excel INDIRECT Function. Excel OFFSET Function. You May Also Like the Following Excel Tutorials: VLOOKUP Vs. INDEX/MATCH Using Excel INDEX MATCH Combo (with examples) Find the Closest Match of a Value in Excel. ...
match_typeOptional. The number -1, 0, or 1. Thematch_typeargument specifies how Excel matcheslookup_valuewith values inlookup_array. The default value for this argument is 1. The following table describes how the function finds values based on the setting of thematch_typeargument. ...
The MATCH function in Excel returns a numeric value, the location of a specific item in the given range. The syntax of the MATCH function is as follows: =MATCH(lookup_value, lookup_array, [match_type]) lookup_value(required) refers to the value to match in thelookup_array. ...
The MATCH function is categorized under Excel Lookup and Reference functions. It looks up a value in an array and returns the position of the value within the array. For example, if we wish to match the value 5 in the range A1:A4, which contains values 1
Now that you know the basic uses of the Excel MATCH function, let's discuss a few more formula examples that go beyond the basics. Partial match with wildcards Like many other functions, MATCH understands the followingwildcard characters: ...
This Excel tutorial explains how to use the Excel MATCH function with syntax and examples. The Microsoft Excel MATCH function searches for a value in an array and returns the relative position of that item.