Drop down menu

  • Thread starter Thread starter Ardus Petus
  • Start date Start date
Helllo,
I am trying to create a dropdown menu with individual pricing for each choice.


fence:
4' stockade is $28
5' stockade is $31
6' stockade is $35

I would like each item to be in the dropdown menu and be priced accordingly.
 
You could use a separate (hidden??) worksheet.

Put the descriptions in column A and the pricing in column B.

Column A ColB
4' stockade fence 28
5' stockade fence 31
6' stockade fence 35

Then give that stuff in column A a nice name.

Now you can use that name as the source for the list in a cell that has
Data|Validation applied (say A1).

Then in B1, you can use this formula:
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

Debra Dalgleish has lots of notes about Data|Validation:
http://www.contextures.com/xlDataVal01.html
 
You must log in or register to reply here.

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 Menu AutoPopulate Contact Info? 2
Modifying Data in Drop Down Menu 2
Date Range Drop Down Menu 1
DROP DOWN MENU "source" 5
Drop down menu 2
How do I change fonts in a DV drop down menu 1
inconsistent dir() behavior 1
Drop Down Menu Title 2

Back
Top