Fuzzy logic

Hi there,

Can someone help me do a fuzzylogic vlookup. I can do vlookups but need to be able to do a fuzzy logic one.

e.g. i have 2 lists of customers that are not identical, as below

Please Login or Register  to view this content.

I require to be able to do a fuzzy vlookup that will be able to put 1213 next to Anglia Crown Catering Limited.

Is this possible please
Thank you for your time
Nathan M

well you could match using a wild card or 2 but it depends on how different your two columns are for your example this works

Good evening Mid61n05

...and welcome to the forum

Originally Posted by Mid61n05

Can someone help me do a fuzzylogic vlookup. I can do vlookups but need to be able to do a fuzzy logic one.

Excel doesn't have a built in "fuzzy find" and it's not a simple task to write one. That said someone has attempted it and posted the code and a turotial here, but don't expect it to be plain sailing.

HTH

DominicB