|
Sorting and matching rows of names with Socials with master list and eliminating the extra names
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 |
Sorting and matching rows of names with Socials with master listand eliminating the extra names
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) Giacomo wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 06:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com