Thanks a lot for sugestion.It looks like you're running Excel 2013. If you can use at least version 2016 you'd be able to use Power Query and a fuzzy join.
In the attached, see table at cell C1 of the Sheet1 sheet. It lists the names from that sheet in the left column, and lists the possible matches on column D from Sheet2 column A, along with a similarity score in column E. I've used conditional formatting to highlight where there's more than one possible match.
However, there is an add-in you can use for earlier versions of Excel here:
Better than I EXPECTED !!!
This is other kind of sample ... Press [ Do It ]-button.
B-columns shows - which row has Match
C... -columns shows - row and parts match (black text) or letter match from beginning ( blue text)
shows rows of Match and parts Matches
I'm already checking...thanks again
Excel VBA - Information, Tutorials, Examples & Resources » Chandoo.org - Learn Excel, Power BI & Charting OnlineExcel VBA – Information, Tutorials, Examples & Resources Excel VBA allows you to automate various activities you do in Excel. We use Excel to analyze data, create reports, prepare charts & presentations, do calculations and understand information. When we are doing all these, we spend quite some...chandoo.org