Creating a List based on your choice from Another List

[Cristi]

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

 

[Chris]

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]

I found 2 links that I think will solve BOTH our problems....

http://www.contextures.com/xldataVal13.html

http://www.xldynamic.com/source/xls.Dropdowns.html

Let me know if these help you. I'm going to be trying all afternoon to get
one of them to work for my application!!! GooD LucK!!

Cristi

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...

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

[quoted text clipped - 14 lines]

Thank You ! ! !
~Cristi