We have four columns A-D. Column A and B are Keys. While column C and D are values.
Column A has number sequence of that ranges from 1-100
Column B has the coordinated text value of Column A's number sequence.
In column C and D have more repetitive similar values from column A.
How do I replace each value in column C and D with the column B's value.