pick up from list depending on another list value picked

  • Thread starter Thread starter Anamika
  • Start date Start date
A

Anamika

Hi,

I have 3 values say A,B,C in Cell C1 in a List (Cell drop down). I hav
another list in Cell C2 with values D,E,F (Cell drop down).

I want only values D and E to drop down when I pick A or B and values
and F to drop down when I pick C.

How can I do this through Excel
 
Back
Top