Results 1 to 16 of 16

Combining Separate Tables With Multiple Values

Threaded View

Killericon Combining Separate Tables... 05-27-2010, 03:25 PM
ChemistB Re: Combining Seperate Tables... 05-27-2010, 03:32 PM
Killericon Re: Combining Seperate Tables... 05-27-2010, 03:51 PM
Killericon Re: Combining Separate Tables... 05-27-2010, 04:12 PM
Killericon Re: Combining Seperate Tables... 05-27-2010, 04:54 PM
Ryan Murtagh Re: Combining Separate Tables... 05-27-2010, 05:12 PM
Killericon Re: Combining Separate Tables... 05-28-2010, 03:59 PM
Killericon Re: Combining Separate Tables... 05-31-2010, 11:59 AM
Killericon Re: Combining Separate Tables... 05-31-2010, 11:19 PM
shg Re: Combining Separate Tables... 06-01-2010, 12:07 AM
Killericon Re: Combining Separate Tables... 06-01-2010, 01:44 PM
ChemistB Re: Combining Separate Tables... 06-02-2010, 09:11 AM
Killericon Re: Combining Separate Tables... 06-02-2010, 03:41 PM
ChemistB Re: Combining Separate Tables... 06-02-2010, 04:33 PM
Killericon Re: Combining Separate Tables... 06-03-2010, 11:01 AM
Glenn Kennedy Re: Combining Separate Tables... 12-14-2020, 12:33 PM
  1. #1
    Registered User
    Join Date
    05-27-2010
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2003
    Posts
    11

    Combining Separate Tables With Multiple Values

    Here's my issue.

    I have 2 spreadsheets. One has names, phone numbers, and addresses. The second has names and another number(Let's call it ID Number). The problem is that the first one has over 14000 entries, while the 2nd one has around 600. All the names in the 2nd table are also in the first one, and so I want to add all the ID numbers to all the matching entries in the 1st table, based on name.

    I've been trying to do this with VLOOKUP, and I can't seem to do it, and feel like an idiot. Can anyone help me out?
    Last edited by Killericon; 06-03-2010 at 11:01 AM.

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