From Virtual-Weltanschauung-PmWiki

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

Retrieved from http://www.virtual-weltanschauung.com/pmwiki/pmwiki.php?n=Main.MATCH
Page last modified on April 25, 2023, at 08:38 PM