Data validation problem

X

xami

Hello,

at first place I would like to say I don´t have very good skill in
excel, so if my question is stupid, please be kind on me ;)

I need to create some function or anything else. I´ve one cell in which
is data validation based on list (app. 5 items). Determinate on which
item of list is selected, in next cell I need to choose from another
list of items.

For example:
in first list there are items: error1,error2,....,error5.
next lists are: error1A,error1B,.....,error1X
error2A,error2B,......
and so on.

so if i choose error 1 - in next cell I can choose only from
error1A....error1X..
so please if you know any solution, or something that could help me, i
would by very happy...

thx
 
D

Dav

I assume you know how to set up data validation based upon lists,
DAta_Validation allow lists. Create a sperate list on your spreadsheet
for each of your options, Place the lists next to each other
eg a30:a40 error1, error2 error3 etc
b30:b40 error1a, error1b etc
c30:c40 error2a, error 2b etc

On the first drop down list for validation just select the range as the
list
For the second cell based on the selction of the list put
offset(b30,0,match(b30,b30:b40,0),10,1)

If there are more than ten options the 10 needs to be increased

regards

Dav
 
Top