Req help matching values across columns in Excel

R

Richard B

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.
 
F

Fred Smith

Just use Vlookup, as in:

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

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