how to see if value matches at all in two columns in excel code example

Example: check if values in two columns are equal excel

=IF(COUNTIF($B:$B, $A2)=0, "No match in B", "")