Hi Pierre,

You might want to try itISFUZZYMATCH() and itFUZZYCOMPARE(), the fuzzy
matching worksheet functions in inspector text:

http://precisioncalc.com/it/itISFUZZYMATCH.html
http://precisioncalc.com/it/itFUZZYCOMPARE.html

They both give you very detailed control over the degree of tolerance
of the fuzzy match.


You'll need to install the Free Edition, which never expires:

http://precisioncalc.com/it/index.html


Good luck,

Greg Lovern

http://PrecisionCalc.com
More Power In Excel



On May 4, 5:46*am, Pierre wrote:
I am looking for a solution to the following problem: I have a long list of
companies in an EXCEL sheet, and would like tofind, company by company, if
there is an approximate match with a name in another long list.
Concretely, I would like to be able to match “Blue Circle Productions” with
“Blue Circle Production”. Any idea? How would I set the degree of tolerance?