Results 1 to 10 of 10

Need to associate columns between 2 spreadsheets as follows;

Threaded View

tomsk111 Need to associate columns... 05-09-2013, 03:25 PM
mth Re: Need to associate columns... 05-09-2013, 03:34 PM
tomsk111 Re: Need to associate columns... 05-09-2013, 03:48 PM
mth Re: Need to associate columns... 05-09-2013, 03:59 PM
tomsk111 Re: Need to associate columns... 05-09-2013, 04:19 PM
  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    5

    Lightbulb Need to associate columns between 2 spreadsheets as follows;

    I have 2 spreadsheets.
    Columns are as follows:


    Sheet1:
     A                           M
    Company Name |  Phone Number
    ABC     333 333 3333
    DEF     444 444 4444
    HIG     555 555 5555
    HIJ     666 666 6666
    Sheet2:
    A                J
    Name  |  Phone Number
    John     555 555 5555
    Bob      333 333 3333
    Tom      666 666 6666
    For Phone numbers that exist in Spreadsheet 2, I want to add another column of Name that match the Phone number.

    Basically I want to associate Names (john bob tom) to the relevant Company Name using the matching Phone numbers.

    If it matters, each spreadsheet has 1000's of names and companies. Also some names and company name's may have NO phone number

    How can this be done?
    Last edited by tomsk111; 05-09-2013 at 03:45 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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