I need get output using excel formuals

[Aravindnantha]

I Want to get Product value on below table using Excel formula

	01-01-2016 <colgroup><col width="73"></colgroup><tbody> </tbody>	01-03-2016 <colgroup><col width="73"></colgroup><tbody> </tbody>	01-04-2016 <colgroup><col width="73"></colgroup><tbody> </tbody>
A
B
D

<tbody>
</tbody>

Below is the source data, i have tried index match but i have duplicates on Name

Date	Product	Name
01-01-2016	60	A
01-01-2016	54	B
01-01-2016	40	C
01-01-2016	60	D
01-03-2016	47	A
01-03-2016	39	B
01-03-2016	46	C
01-03-2016	42	D
01-02-2016	37	A
01-02-2016	53	B
01-02-2016	25	C
01-02-2016	46	D
01-04-2016	49	A
01-04-2016	47	B
01-04-2016	46	C
01-04-2016	27	D

<colgroup><col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:2011;width:41pt" width="55"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> </colgroup><tbody>
</tbody>

Kindly advise

 

[Fluff]

If you will only have one match for both name & date try

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	Date	Product	Name			01/01/2016	01/03/2016	01/04/2016
2	01/01/2016	60	A		A	60	47	49
3	01/01/2016	54	B		B	54	39	47
4	01/01/2016	40	C		D	60	42	27
5	01/01/2016	60	D
6	01/03/2016	47	A
7	01/03/2016	39	B
8	01/03/2016	46	C
9	01/03/2016	42	D
10	01/02/2016	37	A
11	01/02/2016	53	B
12	01/02/2016	25	C
13	01/02/2016	46	D
14	01/04/2016	49	A
15	01/04/2016	47	B
16	01/04/2016	46	C
17	01/04/2016	27	D
List

Cell Formulas
Range	Formula
F2	=SUMIFS($B$2:$B$17,$C$2:$C$17,$E2,$A$2:$A$17,F$1)

 

[Aravindnantha]

Lovely Thanks

 

[Fluff]

You're welcome & thanks for the feedback