Req help matching values across columns in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Just use Vlookup, as in:

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

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