Match partial duplicates in two columns

[Ebippity]

I'm trying to find partial dupes comparing data in two columns and limiting the matches to a specified number of digits.

Ridiculously Simple Example: If column 1 has "1234" and column 2 has "3456" (and these are formatted as text, not numbers), it would match those because they both "34" in them. I would be able to specify that at least 2 consecutive digits have to match.

Here is a sample of the data I'm working with. How do I do this?

[TABLE="width: 570"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]First Column[/TD]
[TD]Second Column[/TD]
[TD]Match Column[/TD]
[/TR]
[TR]
[TD]VV GJ-900-0003492[/TD]
[TD]BLAH[/TD]
[TD]MATCH[/TD]
[/TR]
[TR]
[TD]BLAH GJ-900-0003493 BLAH[/TD]
[TD]BLAH[/TD]
[TD]MATCH[/TD]
[/TR]
[TR]
[TD]MP-002-00214[/TD]
[TD]MANUAL PAYMENTS[/TD]
[TD]NO MATCH[/TD]
[/TR]
[TR]
[TD]MP-900-00101[/TD]
[TD]MANUAL PAYMENTS[/TD]
[TD]NO MATCH[/TD]
[/TR]
[TR]
[TD]VGJ-900-00083[/TD]
[TD]VOID GJ-900-0003492[/TD]
[TD]MATCH[/TD]
[/TR]
[TR]
[TD]VGJ-900-00085[/TD]
[TD]VOID GJ-900-0003493[/TD]
[TD]MATCH[/TD]
[/TR]
[TR]
[TD]GJ-003-0001374[/TD]
[TD]write off year-old GPN[/TD]
[TD]MATCH[/TD]
[/TR]
[TR]
[TD]GJ-003-0001517[/TD]
[TD]write off year-old GPN[/TD]
[TD]NO MATCH[/TD]
[/TR]
[TR]
[TD]VGJ-003-00089[/TD]
[TD]VOID GJ-003-0001374[/TD]
[TD]MATCH[/TD]
[/TR]
[TR]
[TD]GJ-003-0001374[/TD]
[TD]write off year-old GPN[/TD]
[TD]MATCH[/TD]
[/TR]
[TR]
[TD]GJ-003-0001517[/TD]
[TD]write off year-old GPN[/TD]
[TD]NO MATCH[/TD]
[/TR]
[TR]
[TD]VGJ-003-00089[/TD]
[TD]VOID GJ-003-0001374[/TD]
[TD]MATCH[/TD]
[/TR]
</tbody>[/TABLE]


Thank you for any help on this!!

 

[Ebippity]

Oh except I made a mistake. The third row from the bottom of the second column is NOT a match.

 

[Ebippity]

Oh wait... it IS a match. Sheesh. Anyone know how to delete or edit your own posts?

 

[Phuoc]

=IF(COUNTIF($A$2:$A$100,"*"&B2&"*")+SUMPRODUCt(COUNTIF(B2,"*"&$A$2:$A$100&"*")),"MATCH","")

 

[Ebippity]

=IF(COUNTIF($A$2:$A$100,"*"&B2&"*")+SUMPRODUCt(COUNTIF(B2,"*"&$A$2:$A$100&"*")),"MATCH","")

Phuoc, sorry for taking so long to respond. It's been crazy over here! Finally got a chance to test this out and I'm so excited that it's working. Thank you!!!