Finding Approximate Match and Return String

[kshitij_dch]

Hello All ,

I am working on a Project where I need to find out Matching Customer Name from Payee List in Column A

Column A has Payee Details ( Contains Customer Name also has Alpha Numeric and Special Characters )
Column B has Primary Applicant Name
Column C has Co Applicant 1 Name
Column D has Co Applicant 2 Name
Column E has Co Applicant 3 Name
Column F where I need to return Approximate Name Matched in Column A with Name in Columns ( B , C ,D, E)
Column G where I need to return from where I found Matched Name

I looks a bit complicated , With Normal VLookup it is not matching , Can there be a VBA code for this as this has approx. 5000 rows of Data , Very difficult to do manually

Payee Details	Primary Applicant	Co App 1	Co App 2	Co App 3	Matched Name	Approximate Match With
Andi Austin - Real Eatate 001 , A/C No : 1234567890	Lisa Austin	Andy Austin	Mark Tees	Amanda Young	Andy Austin	Co App 1
Danial L - Embark Associates , A/cC No : 0987654321	Mark Vin	Esty Trot	Jonathan M	Danial Levit	Danial Levit	Co App 3