On Wed, 18 Feb 2009 16:38:00 -0800, Wendy
wrote:

Need help. Need to be able to basically perform 2 vlookups. Here is the
example:

Division Part # Cost/ LB Cost/ingredient
12 1253 5 0.8
12 1246 2 0.3
13 1234 1 0.5
13 1278 3 0.6
14 1278 3 0.6
15 1234 1 0.5

I want to be able to write a formula that finds the division number and for
that division number, find the part number I specify and then give me the
cost per pound or cost per ingredient. Can someone help me please? Thanks.

Assuming table is in A1:D7 --

Cost/LB
=SUMPRODUCT(($A$2:$A$7=Division)*($B$2:$B$7=PartNu m)*$C$2:$C$7)

Cost/Ingredient
=SUMPRODUCT(($A$2:$A$7=Division)*($B$2:$B$7=PartNu m)*$D$2:$D$7)
--ron