Sumproduct picking off just one result in the lookup table for multiplication

[davodka]

Hi,

I have item numbers in "incremental net price" and in "Pricing" tab. I'm trying to pull the "Net price" from the "pricing tab" and multply the price by my quanity in the "incremental" tab. Problem is that the pricing tab has multiple results and it just so happens that the values are duplicated somewhat.

So when I do the sumproduct multiplication +SUMPRODUCT(SUMIF(F4:F78,Pricing!B11:B36,H4:H78)*(Pricing!D11:D36)), multiple pricings will be returned, hence doubling the pricing I want. The ultimate number I want to get to is $2,238.73, but when I take one net price off the "pricing tab", the entire equation is evaluating based on the one pricing item short, so simply dividing all the numbers by one half will not work.

So I'm hoping the sumproduct can just pick one result from the "pricing" tab and multiply that by the quanity in the "incremental net price" tab, irrespective of how many duplicates are in the pricing tab.

Someone please help.
[TABLE="width: 500"]
<TBODY>[TR]
[TD][TABLE="width: 723"]
<TBODY>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Item # </SPAN>[/TD]
[TD] [/TD]
[TD] Net Price </SPAN>[/TD]
[/TR]
[TR]
[TD]1757160</SPAN>[/TD]
[TD][/TD]
[TD] 19.01 </SPAN>[/TD]
[/TR]
[TR]
[TD]1760198</SPAN>[/TD]
[TD][/TD]
[TD] 17.52 </SPAN>[/TD]
[/TR]
[TR]
[TD]1820984</SPAN>[/TD]
[TD][/TD]
[TD] 19.01 </SPAN>[/TD]
[/TR]
[TR]
[TD]1821099</SPAN>[/TD]
[TD][/TD]
[TD] 17.52 </SPAN>[/TD]
[/TR]
[TR]
[TD]1454453[/TD]
[TD][/TD]
[TD] 2.48 </SPAN>[/TD]
[/TR]
[TR]
[TD]1454453[/TD]
[TD][/TD]
[TD] 2.48 </SPAN>[/TD]
[/TR]
[TR]
[TD]1454461[/TD]
[TD][/TD]
[TD] 3.39 </SPAN>[/TD]
[/TR]
[TR]
[TD]1454461[/TD]
[TD][/TD]
[TD] 3.39 </SPAN>[/TD]
[/TR]
[TR]
[TD]1454487[/TD]
[TD][/TD]
[TD] 2.72 </SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]


[TABLE="width: 436"]
<TBODY>[TR]
[TD] EM_ITEM_NUM </SPAN>[/TD]
[TD] [/TD]
[TD] QTY </SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1454461</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]7</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1454511</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]3</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1479286</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]3</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1479310</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]4</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1454461</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]2</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1454487</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]2</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1454511</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]3</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1479286</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1479310</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]9</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]3683810</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]2</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1454453</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1454487</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]3</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1454511</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]2</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1479286</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]4</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

Michael