Hi and thanks for considering my scenario.

Column A contains cells with 2 values (letters of the alphabet) in each cell.

The options are: AB, AC, DB, DC.

Column C contains cells with 2-4 values in each cell.

The options are:

AB
AC
ABC
DBC
DA
DC
DAB
DAC
DABC

IF CELL C1 contains any 2 of the values that appear in A1, then B1 = "Yes", otherwise leave cell blank.

I hope this explains what I am attempting to do.

Example: A1 = AB, C1 = AC, B1 = a blank cell.

Example: A1 = DB, C1 = DAB, B1 = "Yes."

Thanks again, Jon