One way:

=IF(COUNTIF(DQ:DQ,DO1),"Match","No Match")

Another:

=IF(ISNA(MATCH(DO1,DQ:DQ,FALSE),"No Match","Match")

In article ,
Toria wrote:

Hello,

I have two columns of names, DO and DQ. I need to know when there's a match
without going row by row and maunally eyeballing it. I've spent all morning
trying to figure out. Any help is much appreciated.

Thank you.