I need get output using excel formuals

[Aravindnantha]

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



[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]

<colgroup><col width="73"></colgroup><tbody>
[TD="class: xl65, width: 73, align: right"]01-01-2016
[/TD]

</tbody>

[/TD]
[TD][TABLE="width: 73"]
<colgroup><col width="73"></colgroup><tbody>[TR]
[TD="class: xl65, width: 73, align: right"]01-03-2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<colgroup><col width="73"></colgroup><tbody>
[TD="class: xl65, width: 73, align: right"]01-04-2016[/TD]

</tbody>

[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Below is the source data, i have tried index match but i have duplicates on Name

<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>
[TD="class: xl65, width: 73"]Date
[/TD]
[TD="class: xl65, width: 55"]Product
[/TD]
[TD="class: xl65, width: 44"]Name
[/TD]

[TD="class: xl66"]01-01-2016
[/TD]
[TD="class: xl65"] 60
[/TD]
[TD="class: xl65"]A
[/TD]

[TD="class: xl66"]01-01-2016[/TD]
[TD="class: xl65"] 54
[/TD]
[TD="class: xl65"]B
[/TD]

[TD="class: xl66"]01-01-2016[/TD]
[TD="class: xl65"] 40
[/TD]
[TD="class: xl65"]C
[/TD]

[TD="class: xl66"]01-01-2016[/TD]
[TD="class: xl65"] 60
[/TD]
[TD="class: xl65"]D
[/TD]

[TD="class: xl66"]01-03-2016[/TD]
[TD="class: xl65"] 47
[/TD]
[TD="class: xl65"]A
[/TD]

[TD="class: xl66"]01-03-2016[/TD]
[TD="class: xl65"] 39
[/TD]
[TD="class: xl65"]B
[/TD]

[TD="class: xl66"]01-03-2016[/TD]
[TD="class: xl65"] 46
[/TD]
[TD="class: xl65"]C
[/TD]

[TD="class: xl66"]01-03-2016[/TD]
[TD="class: xl65"] 42
[/TD]
[TD="class: xl65"]D
[/TD]

[TD="class: xl66"]01-02-2016[/TD]
[TD="class: xl65"] 37
[/TD]
[TD="class: xl65"]A
[/TD]

[TD="class: xl66"]01-02-2016[/TD]
[TD="class: xl65"] 53
[/TD]
[TD="class: xl65"]B
[/TD]

[TD="class: xl66"]01-02-2016[/TD]
[TD="class: xl65"] 25
[/TD]
[TD="class: xl65"]C
[/TD]

[TD="class: xl66"]01-02-2016[/TD]
[TD="class: xl65"] 46
[/TD]
[TD="class: xl65"]D
[/TD]

[TD="class: xl66"]01-04-2016[/TD]
[TD="class: xl65"] 49
[/TD]
[TD="class: xl65"]A
[/TD]

[TD="class: xl66"]01-04-2016
[/TD]
[TD="class: xl65"] 47
[/TD]
[TD="class: xl65"]B
[/TD]

[TD="class: xl66"]01-04-2016[/TD]
[TD="class: xl65"] 46
[/TD]
[TD="class: xl65"]C
[/TD]

[TD="class: xl66"]01-04-2016
[/TD]
[TD="class: xl65"] 27
[/TD]
[TD="class: xl65"]D
[/TD]

</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