I have two columns of text where I'm trying to find out if one of those
columns contains the same text in individual rows as the other column. One of
the columns has more entries/rows than the other. I tried the EXACT function
and tried using the first column entry as an array down the column and the
second column entry as the row that I'm checking it against. Like this
=EXACT(A2:A366, B2).
This didn't produce the result correctly.

Here's a small portion of the columns so you get the idea.
Company Name from Unique TCN Company Name from Pivot
A.G. Edwards & Sons, Inc. A.G. Edwards & Sons, Inc.
AB Chalmersinvest AB Chalmersinvest
Abraham Trading Company ABN Amro Incorporated
Advanced Investment Partners Acadian Asset Management
Alliance Capital Management LP Acta Realty Corporation
Alliance Capital Management LP AEW Capital Management LP
Allstate Insurance Company Afton Capital Management LLC
American Century Invest. Mgmt. AGF Management Ltd.
AMICA Mutual Insurance Co. AIG Global Investment Corp
Analytic Investors, Inc. Aim Advisors, Inc.
Andor Capital Management LLC Alberta Finance
Applied Finance Group Alexandra Investment Management Ltd
Archer Capital Management Alson Capital Partners

As you can see not all of them match but some may in the second colum. The
second column is the longer one. How do I find out which names in the second
column are the same as the ones in the first without manual proofreading?

Thanks in advance,

Paul