|
Main /
MATCHMain.MATCH HistoryHide minor edits - Show changes to markup April 25, 2023, at 08:38 PM
by -
Changed lines 3-5 from:
=IF(ISNA(MATCH(A2,$C$2:$C$140,0)),"",INDEX($C$2:$C$140,MATCH(A2,$C$2:$C$140,0))) to:
=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 April 25, 2023, at 08:35 PM
by -
Added lines 1-3:
=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))) |