one way :

C1: =IF(COUNTIF(A:A,B1),"Match","No Match")

In article ,
Chris(new user) wrote:

I need excel to check two lists of id codes and show if a match exists my
spreadsheet looks similar to this...
Colum A Colum B
axc123564 jku7784554
wes879566 abc123456
abc123456 uujk44521154

I want excel to check if items on colum b appear on colum a and inform me if
a match is found in colum c

This is what I want it to look like

axc123564 jku7784554 No Match
wes879566 abc123456 Match
abc123456 uujk44521154 No match

My sheet contains over 2000 id's
Please help.