Look up a column with duplicates and return from multiple specified columns

Hi,

I have a worksheet where I have a product ID column with multiple duplicates followed by various columns with filled and missing data.

I would like to look up a particular product ID say 111 and find specific features from the various columns about this product eg Colour, #ID , Origin etc.

I have attached a sample workbook with colour coded with desired results.

Any help or direction will be greatly appreciated.


Thank you