Drop Down List Items and Respective [Price] Data

Guest · Dec 8, 2003

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 · Dec 9, 2003

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)

Drop Down List Items and Respective [Price] Data

Guest

Debra Dalgleish