Compare 2 cells MID unknown location

[poikl]

Hi, Can you please help me structure my Conditional Format? I have (with MREXCEL's help, Marcelo)-OR(MID(G2,5,3)=LEFT(H2,3),MID(G2,5,3)=LEFT(I2,3),MID(G2,5,3)=LEFT(J2,3),MID(G2,5,3)=LEFT(K2,3)).
The problem is though that ColG source is from Manual entry where operators enter name, sometimes with Prefix "Mr.", "Mrs.", "Dr." or even "Doctor" and other times with minor misspellings. I'm trying to compare those names to various Customer Data Base, ColH, thru ColK. (That's why I created the "MID" function but as you see it won't catch all probable variations)
Is there a way to include in MID "seemingly alike" entries which may start not necessarily in position 5, but maybe 4, 6 or 7?

 

[FormR]

but I'm stumped why it doesn't recognize the following (2), G2-BELL H2-Bell Materials and similarly G2-V.TANE H2-V. Tane
as a match???

Hi, the first example is only 4 characters long and you said that 5 consecutive characters need to match.

I think this slight amendment handles where the entire text is less than 5 characters:

=ISNUMBER(LOOKUP(1,-SEARCH(MID(G2,ROW(INDIRECT("1:"&MAX(1,LEN(G2)-4))),5),"|"&H2&"|"&I2&"|"&J2&"|")))

The second example does not fit the specification, i.e. there are not 5 consecutive characters that match (note the space after the "V." in the H2 value).