Search each character of cell in another

[noizenconfusion]

Hi Experts -

I do not use excel much at all and would appreciate any help on the problem I have. Please refer to the attachment to understand my problem.

I basically want to take each character of a cell ( B2) and search for it in another cell(B3). If I'm able to find all the characters of B2 in B3, then my result will be C3 = NO, if not, then the result will be C3 = YES.

I want to do this search only if the dates match for the two entries.

In my attachment, B2 = MSC, I want to look for the characters M, S and C in B3. Since I have FMSCDE in B3, therefore my C3 value = NO.

Now I want to search for B4(FMSCSE) in B5(MSC). My C5 value = YES since I'm unable to find the character "F" in B5.

Will be grateful if someone can help me out! Please let me know if I need to provide more details.

Thanks!

[TonyB51]

Hi,

Your problem may have some inconsistancies.

Any way I have modified your spreadsheet, which picks up most of the criteria using the following formula.

=IF(ISNUMBER(FIND("Y",B3)),"No",IF(ISNUMBER(FIND("M",B3)),IF(ISNUMBER(FIND("S",B3)),IF(ISNUMBER(FIND("C",B3)),"No", "Yes"))))

I hope it helps. You may need to expand it.

Cheers

TonyB