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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519262