Home |
Search |
Today's Posts |
#1
|
|||
|
|||
creating drop down lists
I need to create a drop down list for a new program to
figure out prices. I have looked thru the help section with little resolution. If anyone knows a good web page or can get me started I would greatly appreciate it |
#3
|
|||
|
|||
You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he http://www.contextures.com/xlDataVal01.html To return the price for the selected item, you can use a VLookup formula. There are instructions and examples he http://www.contextures.com/xlFunctions02.html There's a sample file that uses Data Validation and VLookup formulas he http://www.contextures.com/excelfiles.html#Function Under Data Validation, look for 'Order Form' Seymour wrote: I need to create a drop down list for a new program to figure out prices. I have looked thru the help section with little resolution. If anyone knows a good web page or can get me started I would greatly appreciate it -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
2 column drop down lists | Excel Discussion (Misc queries) | |||
Change font size in drop down validation lists | Excel Discussion (Misc queries) | |||
Creating Combinations from Two Lists | Excel Discussion (Misc queries) | |||
How do I change the appearance of my drop down lists? | Excel Worksheet Functions |