Try this...

Data in the range A2:D7

Use cells to hold your search criteria.

F2 = some division
G2 = some part number

Enter this formula in H2 for the cost/lb:

=SUMPRODUCT(--($A2:$A7=$F2),--($B2:$B7=$G2),C2:C7)

Drag copy across to I2 for the cost/I.

--
Biff
Microsoft Excel MVP


"Wendy" wrote in message
...
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.