IF Any Of These Values Appear in A1, Then "Yes"

[ThanksAlot]

Hi, and thanks for taking a look at this problem. I think I am looking at =IFERROR(IF(SEARCH(LEFT.... etcetera, but I am stuck.


Cell A1 contains four characters, WXYZ. Cell B1 contains two characters, X3. Cell C1 should result in "Yes" since the character "X" appears in both A1 and B1.

Cell A2 contains four characters, 2468. Cell B2 contains two characters, X3. Cell C2 should remain empty since neither characters "X" or "3" appears in both A1 and B1.

Only ONE similar character should result in "Yes." Not all characters have to appear in A1 and B1. Any similar character will result in "Yes."


Thanks for considering a solution to my problem.

Regards, Jon

[Pete_UK]

Put this formula in C1:

=IF(OR(ISNUMBER(SEARCH(LEFT(B1),A1)),ISNUMBER(SEARCH(RIGHT(B1),A1))),"yes","")

then copy down as required.

Hope this helps.

Pete

[ThanksAlot]

Yeah, Pete! You nailed it. Yours was the magic answer. Thanks for taking the time to help! You're awesome!

[Pete_UK]

Glad to be of help - thanks for the rep.

Pete

[Tony Valko]

Here's another one...

=IF(COUNT(SEARCH(MID(B1,{1,2},1),A1)),"Yes","")