Microsoft Excel , Google Spread Sheet Snippet

Exel: Check if a column value exists in another column or not =NOT(ISERROR(MATCH(E2,$D$2:$D$1000,0)))
Here we are checking if column E2 exist between Column D2 to Column D1000; if yes then output "True",  if not then false. =NOT(ISERROR(MATCH(E2,$D$2:$D$1000,0)))