F
Frank Kabel
Hi
try the following formula in your third sheet
=SUMPRODUCT(--('sheet1!'$A$1:$A$100="D & Q"),--('sheet1'!
$B$1:$B$100=$A2),--('sheet1'!$D$1:$D$100=B$1),'sheet1'!
$C$1:$C$100)*INDEX('sheet2'!$A$1:$C$10,MATCH("D &
Q",'sheet2'!$A$1:$A$10,0),MATCH(B$2,'sheet2'!$A$1:$C$1,0))
Assumptions:
- row one on the third sheet is a heading row
- column A on this sheet stores the items
- cell B2 is the first data row for this formula
try the following formula in your third sheet
=SUMPRODUCT(--('sheet1!'$A$1:$A$100="D & Q"),--('sheet1'!
$B$1:$B$100=$A2),--('sheet1'!$D$1:$D$100=B$1),'sheet1'!
$C$1:$C$100)*INDEX('sheet2'!$A$1:$C$10,MATCH("D &
Q",'sheet2'!$A$1:$A$10,0),MATCH(B$2,'sheet2'!$A$1:$C$1,0))
Assumptions:
- row one on the third sheet is a heading row
- column A on this sheet stores the items
- cell B2 is the first data row for this formula