elsg
08-24-2013, 11:35 AM
I am using a formula to return me to column C of a tab ("PLAN2"). :think:
=SUMPRODUCT(--(PLAN2!$B$2:$B$6721=PLAN1!B2),--(PLAN2!$A$2:$A$6721=PLAN1!A2),PLAN2!$C$2:$C$6721)
PLAN1
Date
Time
Result
16/03/13
18:00:00
0,00
16/03/13
20:15:39
0,00
16/03/13
21:51:07
0,00
16/03/13
22:35:18
0,00
17/03/13
18:45:39
0,00
PLAN2
Date
Time
Value
16/3/2013
18:00:00
65.465,00
16/3/2013
18:01:00
12,00
16/3/2013
18:02:00
545,00
16/3/2013
18:03:00
787,00
16/3/2013
18:04:00
56,00
16/3/2013
18:05:00
87,00
=SUMPRODUCT(--(PLAN2!$B$2:$B$6721=PLAN1!B2),--(PLAN2!$A$2:$A$6721=PLAN1!A2),PLAN2!$C$2:$C$6721)
PLAN1
Date
Time
Result
16/03/13
18:00:00
0,00
16/03/13
20:15:39
0,00
16/03/13
21:51:07
0,00
16/03/13
22:35:18
0,00
17/03/13
18:45:39
0,00
PLAN2
Date
Time
Value
16/3/2013
18:00:00
65.465,00
16/3/2013
18:01:00
12,00
16/3/2013
18:02:00
545,00
16/3/2013
18:03:00
787,00
16/3/2013
18:04:00
56,00
16/3/2013
18:05:00
87,00