How to compare and combine two Excel sheets? (mac Excel 2011)

[Maarten Ramadan]

Hi guys,

I've made a couple of example tables to explain my problem (see tables below). I'm struggling with the following:

I have two sheets. Sheet T1 and sheet T2. I want Excel to take the data from column C from sheet T2 and put it into column D of sheet T1 to form sheet T3.

So Excel needs to find the data from the matching rows and put them together, without skipping or leaving out rows.

If a row from sheet T2 isn't found in sheet T1 it should be added as a new row (it doesn't matter if it's on the bottom or in alphabetic/ascending order, as long as it's added).

If a row from sheet T1 isn't found in sheet T2 value in column D can be empty or 0 as long as the row isn't removed or anything.

Hope somebody can help me out.

Thank you in advanced.

Sheet T1[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]B[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]D[/TD]
[TD]444[/TD]
[/TR]
</tbody>[/TABLE]






Sheet T2
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]999[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]B[/TD]
[TD]888[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]C[/TD]
[TD]777[/TD]
[/TR]
</tbody>[/TABLE]






Sheet T3
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]111[/TD]
[TD]999[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]B[/TD]
[TD]222[/TD]
[TD]888[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]C[/TD]
[TD]0[/TD]
[TD]777[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]D[/TD]
[TD]444[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]