Drop Down List Items and Respective [Price] Data

[L.A.Hambly]

I would like to assigna specific price value to each item in a drop down list and
1. have the price be reflected in the adjacent column AN
2. have a formula total in the TOTAL adjacent colum

I have populated all of the data in an area on the sheet and created the drop-down lists. I just get stuck with assigning respective numerical values to each of the drop-down items. Thanks!

 

[Debra Dalgleish]

There's a sample file on my web site that uses Data Validation and
VLookup to complete an order form. You could use the same technique for
your worksheet:

http://www.contextures.com/excelfiles.html

Look for the heading: Order Form (DataValOrder.xls)