Just use Vlookup, as in:

=vlookup(a2,B:B,1,false) and copy down.

If it returns #N/A, then there was no match.

--
Regards,
Fred


"Richard B" wrote in message
...
I have a worksheet that has over 13,000 records. Column A contains company
names; Column B contains the parent company name, if any was listed. I can
filter column B to nonblanks or use a filter drop down box. I need to find
all the cases where any name in column A matches the name in Column B. For
example, if colum B says Smith Management LLC, I need to find Smith
Management in column A. There are several hundred names in Column B after
filtering to nonblanks.