can i link a variable cost code with a variable sum
 

i have an order form in excel i have a drop down menu listing different
departments which will vary and a cost that will also vary im looking to
calculate my monthly cost based on each department and the cost reflecting
that particular department

can you help?