Hi

I am looking for assistance ( a formula ?)that would match two records
which are almost the same (except for the a few letters. See example
below. Vlookup does not help if the two records are not identical.

PROJECT HARDWARE & ELECTRICAL DISTRIBUTO
PROJECT HARDWARE & ELECTRICAL DISTRIBUTORS

Thanks for you help

Cheers