I have created a workbook. It has two worksheets (WORKSHEET1, WORKSHEET2). Some of the cells within WORKSHEET2 have multiple text values.
For example:
One cell, in WORKSHEET2, may be equal to ="Monday"&", "&"Tuesday"&", "&"Wednesday"&"" which is then represented as "Monday, Tuesday, Wednesday".
In WORKSHEET1 I have dates in row 1 and week days in row 2. I'm trying to create an IF statement, in row 3, that will check the week day in row 2 and if it matches one of the day values in a given cell, in WORKSHEET2, it will return "1". Otherwise it will return "".
I have created the following so far, but this only works with single value cells.
=IF(C2=Table4[@Column3], 1, "")
I can then apply conditional formating to any cells with the value of "1".
However, as stated this only works with single value cells, and some of my cells have multiple values.
Can I create an IF statement that says if any of the values, in the given multiple-value cell, match the week day in row 2 then produce "1" otherwise produce ""?
Bookmarks