Formula for detecting inexact duplicates?

Like this:

=LEFT(A1,5)=LEFT(B1,5) will return TRUE if the first 5 characters match and FALSE if they don't

Thanks for your reply, but wouldn't that mean that the company names in columns A and B would have to line up? I don't necessarily have the same number of companies in both lists, so they wouldn't line up one to one.