See:

http://www.contextures.com/xlDataVal02.html
--
Gary's Student
gsnu200702


"gbc65" wrote:

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)