Return a Value from Multiple Criteria eg between 2 dates

[Humanoj]

I have two tables on separate sheets. One table needs to return the value of the product purchased for a specific date. I am trying to use the formula =INDEX(Sheet1!$a$2:$d$5,MATCH(B2,Sheet1!$b$2:$b$5,0),2) but I think it is only a criteri for the customer and none for the date. Can you help me with this? Thanks.

[TABLE="width: 474, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Customer[/TD]
[TD="align: center"]Product[/TD]
[TD="align: center"]Start Date[/TD]
[TD="align: center"]End Date[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Shampoo[/TD]
[TD="align: center"]8/1/2015[/TD]
[TD="align: center"]8/3/2015[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]soap[/TD]
[TD="align: center"]8/1/2015[/TD]
[TD="align: center"]8/3/2015[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]Towel[/TD]
[TD="align: center"]8/1/2015[/TD]
[TD="align: center"]8/30/2015[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]soap[/TD]
[TD="align: center"]8/7/2015[/TD]
[TD="align: center"]8/31/2015[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]shampoo[/TD]
[TD="align: center"]8/15/2015[/TD]
[TD="align: center"]8/31/2015[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sheet1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: grid, width: 378, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Customer[/TD]
[TD]Total[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2-Aug-15[/TD]
[TD]A[/TD]
[TD]5[/TD]
[TD] =INDEX(Sheet1!$a$2:$d$5,MATCH(B2,Sheet1!$b$2:$b$5,0),2)[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1-Aug-15[/TD]
[TD]B[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]20-Aug-15[/TD]
[TD]C[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]10-Aug-15[/TD]
[TD]A[/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]19-Aug-15[/TD]
[TD]B[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sheet2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]