Results 1 to 2 of 2

Matching on Name to Phone/Email Addresses

Threaded View

caineslum Matching on Name to... 10-21-2011, 06:14 PM
tlafferty Re: Matching on Name to... 10-21-2011, 06:55 PM
  1. #1
    Registered User
    Join Date
    10-21-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Matching on Name to Phone/Email Addresses

    I have a work project in which I am required to produce a list of peoples names with the accompanying email addresses and phone numbers. Sounds easy enough except for the fact the person who designed our Corporate database did so in an awful way so rather than be able to do so in Business Objects, I have to pull a list of names with email addresses first then seperately pull one with names and phone numbers. As part of this project, a list that has name, email and phone number in one row is required.

    Is there a formula where I can match based on the first/last name of a person then bring over their email address/phone number from the next sheet? In the sample I have one sheet with the names and phone numbers then another with the names and addresses. How do I produce a single row that has both? I seem stuck as my Excel skills are lacking in this regard.

    As a note there may not always be a match as in some cases someone with a phone number may not have an email address or vice versa, which is fine. In these cases where they do I need to show that though. I hope I was clear enough...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1