Lookup with 3 conditions

[Salamullah]

Hi Experts.

I have data in sheet1

[TABLE="width: 200, align: left"]
<tbody>[TR]
[TD]AREA[/TD]
[TD]SKU[/TD]
[TD]JAN[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]..[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1001
[/TD]
[TD]10[/TD]
[TD]50[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1001[/TD]
[TD]20[/TD]
[TD]40[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1002[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1004[/TD]
[TD]40[/TD]
[TD]20[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1003[/TD]
[TD]50[/TD]
[TD]10[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]










Sheet 2 Summary
[TABLE="width: 500"]
<tbody>[TR]
[TD]AREA[/TD]
[TD]MONTH[/TD]
[TD]SKU[/TD]
[TD]VALUE[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Jan[/TD]
[TD]1001[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

I need formula in cell D1 for SKU 1001 from Sheet 1 keeping in view of the selection of Area in A1 and B1.

For example currently in summary the value is 10 if I change Feb in B1 the value should come 50

 

[Bo_Ry]

Please try at Sheet 2 D2
=SUMPRODUCT(Sheet1!$C$2:$F$9,(Sheet1!$A$2:$A$9=A2)*(Sheet1!$B$2:$B$9=C2)*(Sheet1!$C$1:$F$1=B2))

 

[Salamullah]

Hi many thanks, its working but its adding because we are using sum, if I need only single value instead of sum what to do ?

 

[Bo_Ry]

Please try at D2

=LOOKUP(2,1/(A2=Sheet1!$A$2:$A$9)/(C2=Sheet1!$B$2:$B$9),INDEX(Sheet1!$C$2:$F$7,,MATCH(B2,Sheet1!$C$1:$F$1,)))
or
=INDEX(Sheet1!$C$2:$F$7,MATCH(1,INDEX((A2=Sheet1!$A$2:$A$9)*(C2=Sheet1!$B$2:$B$9),),),MATCH(B2,Sheet1!$C$1:$F$1,))