How to auto populate cells linked to drop down choices

[camz1313]

I have a document that has part numbers by category; I've assigned them drop downs sucessfully. My next consectutive columns (C, D, E, F) need to auto populate respective descriptions, use etc that go with each part. On sheet 2, Ive complied the data using what was given to me & created filters for the category. I am not sure how to use conditonal formatting or if there is another formula I'm not aware of. (I'm a nube!)

I've attached the document for anybody who can help. The info in Sheet2 needs to be connected to Materials Shortage *Ignore pivot table, I was getting fancy w/something I know even less about, but I want to explore later*