Find and replace words based

[sanket_sk]

Hi All,



Hope you are doing well!!



I have unique query to discuss.

I have thousands of rows data in excel, there are few spelling mistakes, word mismatches in the data.

I have a input table with column names “Find What” and “Replace with”. ( given below sample data which is very small however actual data is very long)

I am looking for formula / VBA who will go through column “A” “Raw Data” check in case of any word matching with column “D” – “Find What” if matches it replaces value of column “E” Replace with.

Could you please help me in achieving this result

Data Table

Raw Data
City Name Pune
Located at Bangalore
It in Chennai
Belongs to Mumbai

Input Table

Find What	Replace with
Puna	Pune
Bangalor	Bangalore
Madras	Chennai
Bombay	Mumbai

Desired result

Raw Data
City Name Pune
Located at Bangalore
It in Chennai
Belongs to Mumbai

 

[rlv01]

Your Data table and your Desired Result table are the same.