Combining tables- HELP

AmberJo · Apr 16th, 2002, 10:49 PM

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.

paludgnp · Apr 17th, 2002, 02:23 AM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 10:49 PM	#1
AmberJo New Member Join Date: Apr 2002 Location: Uni Credit Union Posts: 17	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.

Apr 17th, 2002, 02:23 AM	#2
paludgnp New Member Join Date: Feb 2002 Location: Belgium Posts: 24	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)