I have created a drop down listing a number of products. When i select one on these products in the drop down I would like this to automatically input a cost value in another cell.

Please could someone help on how i could perform this task

Many thanks