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

1	A	111
2	B	222
4	D	444

<tbody>
</tbody>

Sheet T2

1	A	999
2	B	888
3	C	777

<tbody>
</tbody>

Sheet T3

1	A	111	999
2	B	222	888
3	C	0	777
4	D	444	0

<tbody>
</tbody>