Forum Discussion
Solved
Matching data from one column to another and if equal replace with value from another column
Hello, 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 updat...
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.
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.