Sorting and matching rows of names with Socials with master list and
eliminating the extra names That arent on the master list. The master
list consists of 739 names and the Names with Social consist of 1263.
I need to match the social with the 739 Names on the master list.
Anyway to automate this?

Ex.
Column A
MASTER LIST
Amy
Dexter
Rick
Suzie
Tom

Column B
NAMES
Amy
Beth
Dexter
Pat
Rick
Suzie
Tom


Column C
Socials
xxx-xx-xxxx
xxx-xx-xxxx
xxx-xx-xxxx
xxx-xx-xxxx
xxx-xx-xxxx
xxx-xx-xxxx
xxx-xx-xxxx