Index/match/hlookup?

A pivot table without any filled in 'values' will give you unique attribute types and product numbers.
http://www.cpearson.com/excel/pivots.htm

Copy and paste these table headings to get the framework as depicted in your example

Then use
=IFERROR(INDEX(Sheet1!$C$1:$C$20,MATCH($A2&B$2,Sheet1!$A$1:$A$20&Sheet1!$B$1:$B$20,0)),"")

..confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

See attached sheet for example