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

  • Thread starter Thread starter Giacomo
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical functions IF & AND 1
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
to pull out information from certain cells of hundred identical wo 7
Drop Down Menu - Populate a list of matching words. 3
Listing Data with Certain Qualifications 6
Lookup? Match? pulling rows from one spreadsheet to match a text f 3
Excel formula to make AAA-BBB equal to/consistent with BBB-AAA 1
Compare City and State to Master List 2

Back
Top