How do I fiter a drop down list

H

Heinrich

I want to be able to select a code from a drop down. This selection must
filter another list to reduce the chance of choosing the wrong code.
 
J

JB

An exemple:

A B C D
1 Fruit Vegetables Flowers
2 Apple Potato Rose
3 Orange Carrot Tulip
4 Banana Lettuce
5 Spinach

Named ranges on Sheet Lists:
Choice1 =OFFSET($B$1,,,,COUNTA($B$1:$Z$1))
Choice2 =$B:$B

On other sheet:
First choice in B2: Data/Valid/List:
=Choice1

Second choice in C2: Data/Valid/List:
=OFFSET(Choice2,1,MATCH(B2,Choice1,0)-1,COUNTA(OFFSET(Choice2,,MATCH
(B2,Choice1,0)-1))-1)

http://cjoint.com/?bvhokpCID5
http://boisgontierjacques.free.fr/pages_site/listes_cascade.htm

JB
http://boisgontierjacques.free.fr
 
Top