Index/Match/Array based on Values - complicated problem =(

Hello - first post here and hopefully someone might be able to help me a little =)

This problem is indeed complicated from my perspective at least. Per my example, I have a list of categories (colors in the file) which break down a list of codes. This list of categories never changes from time to time. Secondly I have receive data on a monthly basis with an output, also with a code attached.

What I would like to accomplish is to create tables (on a monthly basis) which break down all the outputs categorized by the categories (colors) and then subcategorized by the codes. Every month I receive several thousand outputs to play with.

I think a couple things makes this complicated. First Several outputs may have the same code, which presents problems from a =match perspective which only reads the first value it finds. Second, I'm categorizing ultimately based on the colors which are only linked to the outputs by the codes (seems like a two step ordeal). I fear this involves array formulas, sumproducts, and many other crazy tools I am not good enough at!

Is anyone able to help me with this?? If so I'll be absolutely grateful!! Thank you!