Excel validation for a drop down list

Closed
Chandu - Jul 19, 2010 at 10:04 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 19, 2010 at 12:18 PM
Hello,

I am trying to achieve this :

I have name range CATEGORY 1
Another name range with CATEGORY 2


I have a cell drop down with CATEGORY1 ,
Now , if i select CATEGORY 1 in another cell, it has to give a drop down list of the CATEGORY2 based on my selection.

Please help me, on how to do this as I am not an expert in excel.

Thank you for your help.




1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 19, 2010 at 12:18 PM
0