Fill column "B" & "C" from second page

[johncena]

Here i have attached my sample sheet. I need formula to fill first sheet column "B" & "C" from second sheet data. what formula should do is first sheet column "A" values need to match with second sheet column "A" & first sheet cell "B4 & C4 " cell values need check with second sheet column "B". if that values are matched , second sheet column "C" values should add to first sheet column "B & C"..if u check my sample sheet easily u can understand my question..One values i have add manually.like that i want to fill all the cells from formula..pls help me..

[npamcpp]

try in B5 of the Stock sheet:

=SUMIFS(Sheet3!$C$1:$C$201,Sheet3!$A$1:$A$201,Stock!$A5,Sheet3!$B$1:$B$201,Stock!B$4)

or (this also works in Excel 2003 and earlier, but it is slower):

=SUMPRODUCT(--(Sheet3!$A$1:$A$201=Stock!$A5),--(Sheet3!$B$1:$B$201=Stock!B$4),Sheet3!$C$1:$C$201)

copy right and then down.

[johncena]

thanks a lot friend i have used below formula & it's work fine for me.thanks a lot again.REP+
=SUMPRODUCT(--(Sheet3!$A$1:$A$201=Stock!$A5),--(Sheet3!$B$1:$B$201=Stock!B$4),Sheet3!$C$1:$C$201)