[Solved] Macro to normalize names

[SellMeTv2]

Hello, Is it possible to create a macro to normalize names in column B and place the answer in column A

Currently working with a data base with almost 70,000 rows of data with multiple variations of the same name.

I am using the bellow Vlookup which works great - However due to the nature of calculations excel sometime stops responding and I am forced to sit back and wait for the calculation to finish.

=IFNA(VLOOKUP(C2,'Normalized'!A$2:B$1000,2,),C2)

Thank you for any suggestions.

[Kaper]

As you already have a nice and working formula - before we start writing a macro - how about such solution:

leave one copy of your formula for further reference somewhere in your sheet - most common places would be B2 or Balmost7000 (last row).
Select the other cells in column B : Ctrl + G , B3:B100000, Enter
Copy
Paste Special (in the same cells) as Values

Time to time, especially if you find some new cases to be placed in Normalized workbook, or substantian number of entries were added to main workbook do a "maintenance":
copy formula and then do such copy-paste special operation again.

[SellMeTv2]

Thank you. Sometimes, the best thing is to keep it simple.