Multi Column Drop Down List

Hi,   I am a beginner with excel and trying to create a drop-down list. I want the user to be able to click on a part and the specific part # and cost will populate with it. I figured out how to cr...