Excel Drop Down Menus

My company has asked me to develop a form for them, I need help with on aspect of it. I need a drop down menu that a tech can pick a part from, once picked I need other boxes to be automatically populated with related information, such as part number, man hours for installation, cost per item. is this possible?
Thnak You