is it possible to use an if statement in data validation? i use validation to
select a list for column J based on data in column A, but if a specific value
in column F appears the list for column J must be different ( but will still
contain some of the values if the specific value in column F does not appear)