ayi My preferred answer (modified from Ian's) is: =COUNTIF(some_names,D1)>0 which returns TRUE if D1 is found in the range some_names at least once, or FALSE otherwise. (COUNTIF returns an integer of how many times the criterion is found in the range)
