Creating and Invoice with multiple dependent dropdown lists

[SeanO]

I am trying to create an invoice that has two drop down lists. One is the
Category eg.(audio, video, misc) once I pick one of those the second dropdown
list shows only products related to that category. I would like to choose a
product and have it fill out the price for that product. So it goes category
then description of product and finally price. How would I go about creating
that?

thanks!

 

[jlclyde]

I am trying to create an invoice that has two drop down lists.  One is the
Category eg.(audio, video, misc) once I pick one of those the second dropdown
list shows only products related to that category.  I would like to choose a
product and have it fill out the price for that product.  So it goes category
then description of product and finally price. How would I go about creating
that?

thanks!

As long as there are not more then seven catagories, you could use
this. Create your lists for each department. Audio = A1:A90 with A1
being the name Audio. B1:B45 as video. So on till you have all your
lists. Create a list for each one. To do this highlight the entire
column that has information in it and right click. Chose create
list. My list has headers, if you have selected row 1.

Now you need to make these named ranges. Highlight the information
from each list and select Define/Name/ named ranges. Add a simple
name. you will be able to refer to this range another time with just
using the simple name. After all the inputs have a named range.

Go to the cell that you would liek the first pull down C1. Data/
validation/List/Chose all the headers. the next cell that you want
the pull down to be go to the same thing Data\validation\List\ where
you would normally chose the list put in
Audio w/o quotes is refering to the named range Audio. =IF
(C1="Audio",Audio,Video). this should at least give you a push in teh
right direction.

Jay

 

[Gord Dibben]

See Debra Dalgleish's site for dependent dropdowns using Data Validation
Lists

http://www.contextures.on.ca/xlDataVal02.html

For entering the price use a VLOOKUP formula.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP