Excel: Partial Matches in 2 Different Cells

Solved/Closed
kaiwalls04 Posts 6 Registration date Friday April 4, 2014 Status Member Last seen May 1, 2014 - Apr 9, 2014 at 03:58 PM
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!




Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 10, 2014 at 07:43 AM
try this formula in thefirst M cell and copy dowan

=IF(ISNUMBER(SEARCH(K1,L1)),"match","nomatch")
0
kaiwalls04 Posts 6 Registration date Friday April 4, 2014 Status Member Last seen May 1, 2014
Apr 10, 2014 at 11:53 AM
YES and YES!!!!! you, my friend, are a genius. thank you!
0