=Isnumber(Match(A2,$B$2:$B$3000,0)) will return TRUE if Match found, FALSE if not... copy it down the column...