Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Combining tables- HELP

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Uni Credit Union
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK... here goes...

    I have one table with member no (our unique id), member value and member products and another table with member no and about 20 other columns. I want to combine the two- the only problem is that the 2nd table has some members that the first table doesn't have (table 2 is longer). I want a table that has everything from the 2nd table, plus the extra 2 rows from the 1st table- and I'll want it every month (using fresh data).

    I've tried the data, consolidate thing and can't make sense of it and I can't seem to install the wizard. Pls help.

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Belgium
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In your sheet with 20 columns, just add two columns with the VLOOKUP formula.
    Note that the VLOOKUP formula needs that the member No (your unique ID) is in the first column of your second sheet (with 3 columns only) organised in rows (if in columns, then use HLOOKUP).
    The result is something like this (don't use it as such but use the help files):
    =VLOOKUP(MemberIDinThisline,Sheet2!&A&1:$C$2000,InforToReturnfromDB,false)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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