Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a List based on your choice from Another List
I have a huge problem and need help asap!! I have a spread sheet that I have
managed to figure out how to make a list in. What I want to do is, when someone pics an option out of that list, that the next column of the sheet will have another list that they then choose their next option from..ie Column 1 Column2 (depends on what they pick from the drop down list 1) List 1 Fruit Veggies If they pick Fruit out of the drop down list, then I want the next column to display Cherries, Grapes, Oranges or if they pick Veggies out of the drop down list that the next column displays a list of Carrots, Peas, Beans. I am trying to get this set up for our companies time sheets and job tracking and need AnY help I can get!!!! PlEaSe Email me with AnY HeLp! cristij [at] cergillette [dot] com Thank You ! ! ! ~Cristi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a List based on your choice from Another List
I am glad you posted this question I have the same issue. I was able to do a
VLookup but it only lists the first selection match. If you know that fruit should display: Cherries, apples, oranges etc. It only lists cherries since this is first. Need assistance please... "Cristi" wrote: I have a huge problem and need help asap!! I have a spread sheet that I have managed to figure out how to make a list in. What I want to do is, when someone pics an option out of that list, that the next column of the sheet will have another list that they then choose their next option from..ie Column 1 Column2 (depends on what they pick from the drop down list 1) List 1 Fruit Veggies If they pick Fruit out of the drop down list, then I want the next column to display Cherries, Grapes, Oranges or if they pick Veggies out of the drop down list that the next column displays a list of Carrots, Peas, Beans. I am trying to get this set up for our companies time sheets and job tracking and need AnY help I can get!!!! PlEaSe Email me with AnY HeLp! cristij [at] cergillette [dot] com Thank You ! ! ! ~Cristi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return a price based on a customer from a drop down list | Excel Discussion (Misc queries) | |||
List based on a date | Excel Discussion (Misc queries) | |||
Creating an invoice with a lookup list | Excel Discussion (Misc queries) | |||
Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) |