Excel 2007 : sets of data, if dates are equal use data from cell

[erter]

Hi.

I have a problem that might be an easy fix:

So I have two sets of data, one with time and one with temperature. In column A the dates are listed, in column B the time is listed.

In another sheet I have the same setup. Column A has the dates, and in column B I have temperature.

Now I want a formula that compares dates from both sheets and adds the temperature in the first sheet if the dates are equal:

First sheet:
01.01.2012 20
05.01.2012 40

Second sheet:
01.01.2012 20
02.01.2012 15
03.01.2012 10
05.01.2012 30

I want the result like:
First sheet:
01.01.2012 20 20
05.01.2012 40 30

The problem I am having is that not all the dates are recorded in the two sheets. So I need a formula that compares cell A1 with the whole column A on sheet two and adds the value in the row.

In advance, thank you so much

[Fotis1991]

Hi erter.

If i get your point, then in Sheet1C1, put this formula.

=INDEX(Sheet2!$B$1:$B$4;MATCH(A1;Sheet2!$A$1:$A$4;0))

Hope to helps you.