Need help for below Formula for Index and match

[msarfaraz]

If value require for A1 when date is match i.e. example below, formula require for red font cell

	01/01/2016	01/02/2016	01/03/2016	01/04/2016	01/05/2016	01/06/2016	01/07/2016	01/08/2016	01/09/2016
A	40	50	60	70	80	90	100	110	120
B	12	25	25	2	52	52	52	52	32
C	12	2	2	2	2	5	2	5	2
D	9	8	5	1	2	2	5	6	4
	01/02/2016	01/04/2016	01/05/2016	01/10/2016	01/07/2016	01/09/2016	01/12/2016	01/14/2016	01/15/2016
A	50	70	80	0	100	120	0	0	0
B	25	2	52	0	52	32	0	0	0
C	2	2	2	0	2	2	0	0	0
D	8	1	2	0	5	4	0	0	0

<tbody>
</tbody>

 

[RCBricker]

If value require for A1 when date is match i.e. example below, formula require for red font cell

	01/01/2016	01/02/2016	01/03/2016	01/04/2016	01/05/2016	01/06/2016	01/07/2016	01/08/2016	01/09/2016
A	40	50	60	70	80	90	100	110	120
B	12	25	25	2	52	52	52	52	32
C	12	2	2	2	2	5	2	5	2
D	9	8	5	1	2	2	5	6	4
	01/02/2016	01/04/2016	01/05/2016	01/10/2016	01/07/2016	01/09/2016	01/12/2016	01/14/2016	01/15/2016
A	50	70	80	0	100	120	0	0	0
B	25	2	52	0	52	32	0	0	0
C	2	2	2	0	2	2	0	0	0
D	8	1	2	0	5	4	0	0	0

<tbody>
</tbody>

be sure to change the range references to suit your needs.

=INDEX($B$2:$J$5,MATCH($A7,$A$2:$A$5,0),MATCH(B$6,$B$1:$J$1,0))

thanks,

 

[msarfaraz]

many thanks, when the date is not find its showing error #N/A can it be 0

 

[RCBricker]

many thanks, when the date is not find its showing error #N/A can it be 0

here you go

=IF(ISERROR(INDEX($B$2:$J$5,MATCH($A7,$A$2:$A$5,0),MATCH(B$6,$B$1:$J$1,0))),0,INDEX($B$2:$J$5,MATCH($A7,$A$2:$A$5,0),MATCH(B$6,$B$1:$J$1,0)))

thanks

 

[msarfaraz]

Great, you are super, thanx