Sorting and matching rows of names with Socials with master list and eliminating the extra names

G

Giacomo

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
 
D

Debra Dalgleish

Insert a blank column between the Master List and the Names columns.
In the new column, enter a VLookup formula, to pull the numbers that
match the name. For example, in cell B2:

=VLOOKUP(A2,$C$2:$D$1264,2,0)
 
Top