Aug 16 2022 07:09 AM
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 |
Aug 16 2022 07:20 AM
SolutionIn B2:
=IF(ISNUMBER(MATCH(A2,B:B,0)),"Match","No Match")
or
=IF(COUNTIF(B:B,A2),"Match","No Match")
Fill down.
Aug 16 2022 07:42 AM
Aug 16 2022 07:49 AM
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.
Aug 16 2022 07:20 AM
SolutionIn B2:
=IF(ISNUMBER(MATCH(A2,B:B,0)),"Match","No Match")
or
=IF(COUNTIF(B:B,A2),"Match","No Match")
Fill down.