Search names between sheets
- Thread starter Danilão
- Start date
p45cal
Well-Known Member
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:
I haven't tried it!
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:
Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center
The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel.
www.microsoft.com
Thanks a lot for sugestion.
It is regrettable that in my job it isn't at least 2016, and even worse, to make downloads you need an administrator password .
If the person has 4 parts, or more, I think that 3 parts would help me
Danilão
You seems to skipped my 'spaces' questions ....This is other kind of sample ... Press [ Do It ]-button.
Sheet1:
B-columns shows - which row has Match
C... -columns shows - row and parts match (black text) or letter match from beginning ( blue text)
Sheet2:
shows rows of Match and parts Matches
Better than I EXPECTED !!!
Very Very Good
How did you make this code? I would like to learn
Last edited:
Danilão
You could start from this ... from Chandoo.org
Excel VBA - Information, Tutorials, Examples & Resources » Chandoo.org - Learn Excel, Power BI & Charting Online
Excel 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
I'm already checking...thanks againDanilão
You could start from this ... from Chandoo.org
Excel VBA - Information, Tutorials, Examples & Resources » Chandoo.org - Learn Excel, Power BI & Charting Online
Excel 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...