Forum Discussion
Solved
matching names from 1 column with another
I have a list of names from column A, and trying to see if there is a match in column B. kept trying a few formulas, but i'm doing something wrong and it's not working. Basically, if john doe i...
In B2:
=IF(ISNUMBER(MATCH(A2,B:B,0)),"Match","No Match")
or
=IF(COUNTIF(B:B,A2),"Match","No Match")
Fill down.
In B2:
=IF(ISNUMBER(MATCH(A2,B:B,0)),"Match","No Match")
or
=IF(COUNTIF(B:B,A2),"Match","No Match")
Fill down.