Match two lists

[PeterTaylor]

Dear all,
I am running excel 2013. I have two lists; List 1 has duplicates and semi-duplcates eg

[TABLE="class: grid, width: 335, align: left"]
<tbody>[TR]
[TD]PAYMENT TO CGU INSURANCE    124C00598050435331[/TD]
[/TR]
[TR]
[TD]BOULDER TRADING POST BOULDER[/TD]
[/TR]
[TR]
[TD]BP GOLDENGATE 1896 \KALGOORLIE        AU[/TD]
[/TR]
[TR]
[TD]BUNNINGS 435000 KALGOORLIE[/TD]
[/TR]
[TR]
[TD]BPAY SYNERGY                       {392306}[/TD]
[/TR]
[TR]
[TD]TELSTRA PAYBYPHONE MELBOURNE[/TD]
[/TR]
[TR]
[TD]BPAY TELSTRA BILL PAYME            {381204}[/TD]
[/TR]
[TR]
[TD]SUPER CHEAP AUTO KALGOORLIE[/TD]
[/TR]
</tbody>[/TABLE]

List 2 has unique records eg:

[TABLE="class: grid, width: 335, align: left"]
<tbody>[TR]
[TD]Boulder trading Post[/TD]
[/TR]
[TR]
[TD]BP Golden Gate[/TD]
[/TR]
[TR]
[TD]Bunnings[/TD]
[/TR]
[TR]
[TD]CGU INSURANCE[/TD]
[/TR]
[TR]
[TD]Synergy[/TD]
[/TR]
[TR]
[TD]Telstra[/TD]
[/TR]
</tbody>[/TABLE]

I want to scan list 1 with list 2 and if a match or partial match is found populate the adjcent cell in list 1 with the value from list 2; if no match is found copy the value in list 1 to the adjacent cell. eg:

 [TABLE="class: grid, width: 700, align: left"]
<tbody>[TR]
[TD]PAYMENT TO CGU INSURANCE    124C00598050435331[/TD]
[TD]CGU INSURANCE[/TD]
[/TR]
[TR]
[TD]BOULDER TRADING POST BOULDER[/TD]
[TD]Boulder trading Post[/TD]
[/TR]
[TR]
[TD]BP GOLDENGATE 1896 \KALGOORLIE        AU[/TD]
[TD]BP Golden Gate[/TD]
[/TR]
[TR]
[TD]BUNNINGS 435000 KALGOORLIE[/TD]
[TD]Bunnings[/TD]
[/TR]
[TR]
[TD]BPAY SYNERGY                       {392306}[/TD]
[TD]Synergy[/TD]
[/TR]
[TR]
[TD]TELSTRA PAYBYPHONE MELBOURNE[/TD]
[TD]Telstra[/TD]
[/TR]
[TR]
[TD]BPAY TELSTRA BILL PAYME            {381204}[/TD]
[TD]Telstra[/TD]
[/TR]
[TR]
[TD]SUPER CHEAP AUTO KALGOORLIE[/TD]
[TD]SUPER CHEAP AUTO KALGOORLIE[/TD]
[/TR]
</tbody>[/TABLE]

thank you in advnce for your assistance.
Regards,
Peter

 

[sheetspread]

Try:

http://www.mrexcel.com/forum/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html

or https://www.youtube.com/watch?v=3v-qxcjZbyo (I've never used this one)

 

[PeterTaylor]

Try:

http://www.mrexcel.com/forum/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html

or https://www.youtube.com/watch?v=3v-qxcjZbyo (I've never used this one)

Thanks Spreadsheet,
A good direct; it will do just what I want. I can see this is going to be a well used addin at this address.
Reagrds,
Peter

 

[CFranco]

Hi Peter,

Take a look at this application:

https://iugumsoftware.com/