Excel Function : MATCH
Category
Lookup and reference
Description
Looks up values in a reference or array
Microsoft Excel Reference Page
https://support.office.com/en-us/article/MATCH-function-e8dffd45-c762-47d6-bf89-533f4a37673a
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.
