Combine lines that have one cell matching?

[aaronrobb]

This may be an easy one, but I just can't think of how to accomplish this.

I have two sheets, both with different columns, except one column that is an 'ID'. This ID is what matches the info in sheet 1 with the info in sheet 2.
What I need to do is combine the sheets so that sheet two adds its columns to the end of sheet one, but each row must match the specific column that the row is associated with. BUT the lines are not equal in each sheet, meaning its possible for an ID on sheet 1 to not have a row in sheet 2.

For example:

Sheet 1: A1(ID)=1234, B1=red, C1=Blue D1=Purple
Sheet 2: A14(ID)=1234, B14=Dog, C14=Cat, D14=Banana

What I want the end result to be is:

Sheet 1: A1(ID)=1234, B1=red, C1=Blue D1=Purple, E1=Dog, F1=Cat, G1=Banana

So it adds the info from sheet two to the end of the correct line in sheet one, based on the ID matching.

Is this possible??? There are way too many lines to do manually without going crazy.

[JBeaucaire]

1) On sheet1, put this formula in E1:

=IF(ISNUMBER(MATCH($A1, Sheet2!$A:$A, 0)), INDEX(Sheet2!B:B, MATCH($A1, Sheet2!$A:$A, 0)), "")&""

2) Copy that cell down and across as far as needed, even more than 3 columns if you wish.

3) Highlight the full columns you added, for instance E:G

4) Copy

5) While it's still highlighted, do a PASTE SPECIAL > VALUES to remove the formulas and leave the data.