Match 2 names EXACLY

[hsandeep]

2 columns contains names which I am trying to MATCH EXACTLY & get the result "MATCHED" or "NOT MATCHED" in another column.
Rule: First 7 alphabets & last 5 alphabets should MATCH EXACTLY.
Ex:
C3=AAABBBCCCDDDEEEFFFGGG
D3=AAABBBCZZZZFFGGG
E3=MATCHED
In above example: if D3=AAaBBBCZZZZFFGGG, E3="NOT MATCHED"

How to accomplish?

 

[Vidar]

Hi

In E3:
=IF(AND(EXACT(LEFT(C3,7),LEFT(D3,7)),EXACT(RIGHT(C3,5),RIGHT(D3,5))),"MATCHED","NOT MATCHED")

Vidar

 

[hsandeep]

Vidar,

If C3=AFFGGG
If D3=AFFGGG, will it take care?

 

[Vidar]

Hi
It will only work for text strings you specified in your first post.
If you have other text string patterns, then you should list them up together with the results you seek.

Vidar

 

[hsandeep]

What to do then? C3 & D3 can have MINIMUM 1 alphabets to MAXIMUM 200 alphabets.

 

[Rick Rothstein]

What to do then? C3 & D3 can have MINIMUM 1 alphabets to MAXIMUM 200 alphabets.

Explain to us, in detail, how your matching rule works when there are less than 12 characters.

 

[hsandeep]

C3=ABCDEFGHI
D3=ABCDEFFFFFFFEFGHI
Rule: FIRST 7 alphabets & LAST 5 alphabets should MATCH EXACTLY.
For C3, FIRST 7=ABCDEFG & LAST 5=EFGHI
For D3, FIRST 7=ABCDEF & LAST 5=EFGHI
So answer=MATCHED
If D3 would have been=ABCDEFGEFGH
For D3, FIRST 7=ABCDEF & LAST 5=GEFGH
So answer=NOT MATCHED

 

[Rick Rothstein]

I think this might work...

=IF(OR(LEN(C3)<7,LEN(D3)<7),"NOT MATCHED",IF(AND(EXACT(LEFT(C3,7),LEFT(D3,7)),EXACT(RIGHT(C3,5),RIGHT(D3,5))),"MATCHED","NOT MATCHED"))