Need help with look up and return minimum value
 

Hi,

I need help with look up and return min qty. On sheet 1, I have parent
item# GB2 on A2. qty on B2, and on C2, I want to lookup GB2 from sheet 2 and
return kit's qty. I can assemble CB2, LL1, LL2 to make 4 GB2 from first
sequence, and BB2, LL1, LL2 to make 20 GB2 from second sequence.

However, if first sequence kit's qty <5 then look up and returnd second
sequency. I want a formula to lookup and return the lowest kits' qty from
each sequence. IF both sequence kits qty < 5, then return 0.

e.g. on sheet 2

parent item# sequence kit item# kit qty
GB2 10 CB2 4
GB2 20 LL1 20
GB2 30 LL2 30
GB2 110 BB2 25
GB2 120 LL1 20
GB2 130 LL2 30