Excel check if a value in column A exists in column B

Microsoft Excel – Checking if value in Column A exists in Column B

=IFERROR(IF(VLOOKUP(A2,$B:$B,1,FALSE)=A2,"EXISTS"),"DOESNT-EXIST")