Search for best match with strings

Hy everyone,

I was looking for AddIns and macros to find a way to search and find the best match with strings. But no luck. Can you please help me?
In column A are different strings. Take the first (A2) and search for the best result that matches in Column E. Then copy the best result after searching to B2
and show the percentage of matching. Then take A3 and do the same again.
I guess this is a big thing to do, but thanks for your help.

Kind Regards
Roman

Hi 6StringJazzer (great name, I love Wes Montgomery),
I have strings and numbers in different cells. I always had to search where these strings and numbers are in my original datas. It would be great if there is something, that checks the strings and numbers I get and if there are cells in which all of these informations are in my database. Of course not always 100%. I searched a lot of different ways to match this but I had no luck...
Thanks
Kind Regards

FWIW this gives the results in your sample.

Please Login or Register  to view this content.

Hi,
thanks for the macro. I have tested it. It looks really good. I will test it with my original data. This will take some time but I let you know if it works.
I saw some functions with Levenshtein
'

Please Login or Register  to view this content.

How can I use this in my workbook? This looks also interessting.
Kind Regards
Roman

Please Login or Register  to view this content.