=index($l:$l,if(iserror(match(r1,$l:$l)),match($l$2,$l:$l),match(r1,$l:$l)+1)):index($l:$l

Hi there....
I am using excel 2013...when I use this formula in data validation, I got message "you may not use reference operators (such as unions, intersections, and ranges) or array constants for data validation criteria." can anybody help please.