I am fairly new to excel.
I am trying to put together a quotation worksheet for a friend but am having great difficulties. I am creating a quotation spreadsheet, what my friend would like is, through a drop down list to be able to click on a name in that drop down list and for that name to be linked with specific prices. Every name has a different set of prices and therefore cannot be calculated off the same sheet. Here is an example of the price list of one of the names IVORY BROWN
THE QUESTION IS HOW TO CREATE A SPREADSHEET THAT USES THE DROP DOWN LIST TO ACTIVATE A NEW SET OF PRICES FOR THE SELECTED NAME?

Material: Ivory Brown Date


30mm Granite Required Polishing Required

Length Width Total M² Edge Detail Qty Mts Cost
0 Square £0.00
0 ½ Round £0.00
0 Full Round £0.00
0 Total: £0.00
0
0 Cut Outs Required
0
0 Type Qty Cost
Total M²: 0 Sink Polished £0.00
Sink Unpolished £0.00
20mm Granite Required Belfast Sink £0.00
Drainer Grooves £0.00
Length Width Total M² Tap Hole £0.00
0 Hob Cut Out £0.00
0 Radius Ends £0.00
0 Total: £0.00
0