Excel Function : MATCH

Download now!

Excel Function : MATCH


Lookup and reference


Looks up values in a reference or array

Microsoft Excel Reference Page


Syntax and Description of the MATCH Excel Function

I'm trying to match a value in one column with a value in another column, and if there is a match I want the value in the second column to be replaced with the value in the first column. So I have "2.5" in Column A and "2.5.1" in Column B, and I want to replace "2.5.1" with "2.5" in Column B. I'm using the syntax: =MATCH(B2,A2:A6,0) However, I'm getting an error:

Error: Function MATCH parameter 1 value is 2.5.1.

About MATCH Excel Function

The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula MATCH(25,A1:A3,0) returns 2, because 25 is the second item in the range.