DROP DOWN BOX

HI,  IM FAMILIAR TO EXCELL BUT STILL NEWER TO EXCELS FURTHER ADVANCED OPTIONS.   WHAT I AM TRYING TO GET IS A DROP DOWN BOX WHERE I CAN CHOOSE A PRODUCT NAME AND IT WILL PUT THE TOTAL PRICE IN ...