lookup with mutiple returns

[mheinmiller]

i am trying to lookup up when ppart matches spart and subtract total shipped from total produced. Here is where I am getting stuck .... because spart has multiple returns

LOOKUP(2,1/((I2=C:C)),J2)


that's it ...thanks!

[NBVC]

Can you supply a sample in Excel .xls format and then show some expected results in the appropriate locations.?

[mheinmiller]

i dont know if this file uploaded, but basically i need a formula to find the difference:


S Part # Units Shipped Ttl shipped P Part # Total produced difference
35601 10 10 35601 20 10
35603 5 15 35603 25 10
35603 5 15 35623 100 -100
35603 5 15 35659 50 -50

[NBVC]

Is this what you are looking for?

In F2:

=$E2-SUMIF($A$2:$A$12,$D2,$B$2:$B$12)

copied down