Excel Formula Assistance

I have a spreadsheet with 2 sheets, one called parts and the other called colors - Parts has 4 columns (A=parts, B=Code, C=Color, D=qty) The column names are on line 1 and the table extends to line 7...