Macro for Duplicates and replace with other coulmn value

Hello Team,

The column "name" must match with column "formula"


ex :the Value "Calculation_385057835130777604" must match in column "Formula" and must replace with column "Caption" value

"Calculation_385057835130777604" must change to "Year_Brand"


Thanks in advance


Regards
Rohit