Somebody posted something like this last week and it was never solved. Is
this too much for Excel?

A1 thru An contain the names of companies. B1 thru Bn contain another list
of companies. Each list was created by different people at different times
from different sources. Most of the names in the first list should be in the
second list. Is it possible to match the names to get something showing the
% match? Maybe counting the number of consecutive letters that match even if
they're in a different position or something. Or maybe ignore things like
"Inc." So the end result would look like this:

Company_list_1 Company_list_2 Matches with
%
AT&T AT&T B2
100%
IBM Wal-Mart B4
100%
WalMart IBM, Inc B3
90%
Sears Ford
Ford Motors Southwest Airlines B4
40%