Using special characters in Data Validation

[Kumar M B]

hi,
This is my first post on Chandoo.org.
I have a set of data which i need to have multiple levels of data validation. These data have couple of special characters like "-" "+" and " ". Is there a way we can use these characters in Data validation as it is not allowing me to use any special characters as well as space.

i have attached an excel sheet where i need the final criteria drop down to show the list of options available

Thanks in advance!!!

 

[Kumar M B]

Here is the attachment

 

[Chihiro]

Not sure what exactly you mean. Can you use dropdown list?

If not you can still use validation list (named range) and formula.

Set up named range with list of valid entry (lstSpecial).

Then use Custom for validation and use formula.

Assuming data validation is applied to A2...
=MATCH(A2,lstSpecial,0)>0

If this isn't what you want. Upload sample set up with desired outcome entered manually.

 

[Chihiro]

Something like attached?

Using selection in 2nd criteria and match to $E$1:$M$1 to offset column.

 

[Kumar M B]

Thanks a lot... that worked for me