Vlookup l match|search|find

[JimSenthil]

I want to mach 2 columns
A is the unique list of name's static
B is unformatted console list
In C want Names that matches,and very close and higher/approximate possibile name to get captured

In D column is any way to put an remark 100%,90%,80%,.....no match...

 

[Alex Blakenburg]

Given what you want I would be looking at installing and using the Microsoft Excel Fuzzy Lookup Add-In.
You can find it here:
Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center

While the functionality has now been incorporated into Power Query. The Power Query version does not show the % match while the Add-In does.
(which I find very disappointing)

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Matching unformed name's
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.