Combining tables- HELP

AmberJo

New Member
Joined
Apr 15, 2002
Messages
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.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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)
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,254
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top