 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2007Sorting 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 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) > Sorting and matching rows of names with Socials with master list and > eliminating the extra names That arent on the master list. The master [quoted text clipped - 30 lines] > xxx-xx-xxxx > xxx-xx-xxxx  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.