Problems with lists and dat validation

[jmoncada]

Hello,

Given a situation like this:
vegetables: carrots, onions, peas
meat: beef, lamb, chicken
drinks: wine, beer, water

I have crated a validation data list with (vegetables, lamb and drinks)
but I would like to create another validation date list for another
column which depends on the choice of the first list. p.e. If I choose
Vegetables in the first cell I would like to have a drop-down menu with
only carrots, onions, peas in the second cell but if I choose meat in
the first cell I would like to have a drop-down menu with only beef,
lamb, chicken in the second cell.

Is it possible?

Thanks in advance

Pep

 

[Edmund Seet]

The below link to Debora Dalgleish webpage has the answer
for u (precise & concise example):

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

HTH
Edmund Seet

 

[jmoncada]

Thank you very much Edmund. You were very quick in your answer.
Cheers