So basically given the table or spreadsheet posted.
Basically I need a summary table.
Normal Special

I need to enter number depending on the color. So for example this are the codes.
Blue=1, Red=2, Yellow=3,Black=4, Green=5

So IF ID's in column C match, then I need to check which color it is an depending on which color then display the appropiate number.
So like I mentioned when 1233=1233 match, I need to display in the Normal and Special Columns a 1, because 1 = Blue. In some cases One will be for example Blue and the other red. So This would be a 1 and 2.

Perhaps this can't be done with a formula, and I need to use VBA but I appreciate any help.

Thanks