|
Main /
MATCH=IF(ISNA(MATCH(A2,$C$2:$C$140,0)),"",INDEX($C$2:$C$140,MATCH(A2,$C$2:$C$140,0))) =IF(ISNA(MATCH(A2,$C$2:$C$140,0)),"",INDEX($C$2:$C$140,MATCH(A2,$C$2:$C$140,0))) two columns , A and C, with similar text. Finding which match and which do not |