SOLVED

New Contributor

# 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 is in column A, and found in column B, column C says match. If there is no name matching, column C not matching.

 name name 2 match ? smith,david smith,david smith,john smith,john doe,john doe,jane doe,jane doe,john smith,jane smith,janet hick,david david,hick
4 Replies
best response confirmed by nerdyplayer (New Contributor)
Solution

# Re: matching names from 1 column with another

In B2:

=IF(ISNUMBER(MATCH(A2,B:B,0)),"Match","No Match")

or

=IF(COUNTIF(B:B,A2),"Match","No Match")

Fill down.

# Re: matching names from 1 column with another

oo that worked. Also 1 more question. Turns out the reasoning why it wasn't working as well was there was a space in the name that caused them not to match.
smith,john jr[ ] smith,john jr
smith,david[ ] smith,david[ ]

There a quick way to remove the space at the end of the cell? If i try to find and replace all the [ ] then their middle name crunches together. ty

# Re: matching names from 1 column with another

For example:

=IF(ISNUMBER(MATCH(TRIM(A2),TRIM(B\$1:B\$1000),0)),"Match","No Match")

I'd avoid using the entire column here. Adjust the range B\$1:B\$1000 as needed.

YAY! thank you.

i'd hug you.