Drop Down List Items and Respective [Price] Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list selections creating values in adjoining cell 1
Create a drop down that adds up a price 1
Dependent drop down dynamic range formula, off sheet. 7
Populating Data From Drop-Down Item 1
SUM determined by drop-down list 9
Showing information according to a selection in a drop down box 2
Limit drop down list and linking to other info 13
Drop Down with dynamic named range offsheet source list 14

Back
Top