|There are lots of ways to accomplish your goal. One such way is...|
With your values in A1:B8, put this in C1 and drag it down to C8. It will tell you which Column A values match a Column B value and which ones don't.
=IF(ISNA(MATCH(A1,$B$1:$B$8,0)),"No Match For "&A1,"There's A Match For "&A1)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.