need help with If ,Index and Match

[shahdelsol]

I am not sure what I am trying to do will be resolved by IF and Index and Match. Here is the scenario. I am matching value in B7 with N7:N13, Once found then looking for matching the value of C5 in O7:013, if match found, 1 , if False 2
One caveat is the value in C5 is the name of weekdays like Monday, Tuesday etc. the cells in O7:O13 could have two weekdays in one cell like Monday, Tuesday. So if C5 says Monday but O7 says Monday, Tuesday for me it is a match. I hope someone can help. Thanks


=IF(INDEX(N6:O13,MATCH(B7,N6:N13,0),MATCH(C5,O6:O13)),1,2)

 

[shahdelsol]

This new function worked as well. I am going to use this one so I can use my original code for just in case. Thanks again.