Validation lists

ren

New Member
Joined
Oct 23, 2006
Messages
3
I have a validation list of 11 available names in column A; Potato, Onion, Carrot, Parsnip, Apple, Orange, Pear, Banana, Kiwi, Chicken and lamb. There are 3 groups; Vegetables, Fruits and Meat. There are 4 Vegetables, 5 Fruits and 2 different types of meats. If Orange is the name selected from the validation list in cell A1, the list available in cell B1 (Column B) should only be the remaining 4 fruits (Apple, Pear, Banana and Kiwi.) If Chicken is selected in cell A2, then only lamb should be available to select in cell B2. How do I get column B lists to be dependant on what is selected in column A?? How do I do this??? Please Please Help!!! :(
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

ren

New Member
Joined
Oct 23, 2006
Messages
3
This is great, but Ihave THREE categories and I need the list in column A to remain as those names listed, rather than category names. Can you help?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,918
Messages
5,545,025
Members
410,647
Latest member
bernardazar
Top