drop down menu with different price list that reflect on other cells

bisho0o 

Here's a demo file I created for somebody else with a similar question. The methods it uses, to create drop down (data validation) lists that change based on a prior selection from a prior drop down, can readily be deployed in your situation. They DO take advantage of Dynamic Array functions that are only available in the newest releases of Excel.