try =COUNTIF(A:A, B1)>0 this will give you TRUE/FALSE

For Match foun add one more IF statement

=IF(COUNTIF(A:A, B1)>0, "Match found", "Match not found")