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

Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
- - Latest reply: kaiwalls04
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
- Apr 10, 2014 at 11:53 AM
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!




See more 

1 reply

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

=IF(ISNUMBER(SEARCH(K1,L1)),"match","nomatch")
kaiwalls04
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!