# Excel: Partial Matches in 2 Different Cells [Solved/Closed]

Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
-
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
-
Hello,
I've been mulling over this all afternoon and need some help. Here is what my sheet looks like:

K L
3 M1F RP/M1F
4 M1F Gray
5 CB RP
6 RP RP

What I need is the following- If 3 of the letters in K3 match L3, column M should say Match. If they do not, column M should say Mismatch.

Another layer to this formula should be that if column K and L should match and be either RP or M3L2, it should say Additional. So far, all I could come up with is
=MATCH(LEFT(K3,5)&L3,L:L,0)

Any help is GREATLY appreciated! Thanks!

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
try this formula in thefirst M cell and copy dowan

=IF(ISNUMBER(SEARCH(K1,L1)),"match","nomatch")
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014

YES and YES!!!!! you, my friend, are a genius. thank you!
Recommended

DON'T MISS

TRENDING GAMES & APPS
• Internet

• Video games

• Video games

• Video games

• Internet

• Internet

• Internet

• Health

• Video Calls

• Audio