Matching data from one column to another and if equal replace with value from another column

New Contributor


I have a column1 of data that has some incorrect values.  I have the list of incorrect values from column1 in column2 along with the correct value located in column3 and I would like to update the data in column1 with the correct value of column3 if it is found in the list of incorrect values in column 2.


i.e if column1 value is in the list of values located in column2 then replace the value in column 1 with the correct value in column3. 


Is there a way I can do this.


Thank You,


2 Replies
best response confirmed by Hans Vogelaar (MVP)


An alternative could be Power Query. In the attached file you can add data in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh.

matching data.JPG