Able to combine Data entry Validation criteria?

[Guest]

I have two types of Data Validation criteria I am trying to combine, and
wondering if it's possible. Here's the two types of validation I am trying
to enforce for a column:
1. Only values at all if the adjoining cell to the left has a value equal to
"FooType". Any other values in the adjoining left cell would disallow a
value being entered.
2. Only allow values from a List, the Source is in range A2:A50.

E.g. The column with the data validation is K.
1. J6="blah", K6 would not allow any values and would be empty.
2. J6 is empty, K6 would not allow any values and would be empty.
3. J6="FooType", K6 would allow a value, and only from the source in A2:A50.

I am able to set up either validation separately, but cannot figure out a
way to combine the two. FYI, my custom validation resembles: =EXACT(J6,
"FooType")

Thanks for looking!
-brandon

 

[Frank Kabel]

Hi
try the following custom criteria:
=(EXACT(J6,"FooType"))*ISNUMBER(MATCH(K6,$A$2:$A$50,0))