Combining Look-up, If and Sumifs

I have a very complicated formula which I don't know if it's even possible.

My Conditions are:

Look-up code(F3 = Code 03) from column A
Then compare quantity(G3) to 1st row of Code 03.

Is G3 less than B12(Code 03 1st row)? If yes, return D12 to H3
If No, is G3 less than B12+B13(1st and 2nd row of Code 03)?
If this time yes, return B13 to H3
If No again, is G3 less than B12+B13+B14(1st, 2nd & 3rd)?
If this time yes, return B14 to H3
and so on.....

I attached a sample file for you to look at...

For Columns I and J, I'm still trying to figure out what are the conditions that I need to return the data.
But if you can help me with that also it'll be great!


Thanks in advance for helping!!!

Doing this with single cell calculations would be quite complex and inefficient I think... moreover returning the concatenated strings would prove very difficult without use of either VBA or Helper cells.

Below is one approach which though not elegant does do what you want - I think...

Using your sample file:

Please Login or Register  to view this content.

With the above in place you can now create your summary table formulae

Please Login or Register  to view this content.

the results with the above in place replicate all of your expected results.

edit: added working example for sake of demo.