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
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
have a look here
http://www.contextures.com/tiptech.html
--
Don Guillett
SalesAid Software
[email protected]
"Seymour" <[email protected]> wrote in message
news:[email protected]...
> 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
You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and here:
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 here:
http://www.contextures.com/xlFunctions02.html
There's a sample file that uses Data Validation and VLookup formulas here:
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks