Lookup with 3 conditions

[Salamullah]

Hi Experts.

I have data in sheet1

AREA	SKU	JAN	Feb	Mar	..
A	1001	10	50	10
B	1001	20	40	20
C	1002	30	30	30
A	1004	40	20	40
B	1003	50	10	50

<tbody>
</tbody>

Sheet 2 Summary

AREA	MONTH	SKU	VALUE
A	Jan	1001	10

<tbody>
</tbody>

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,))