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
Bookmarks