Work Schedule Help - Index & Match Arguments

[cy83rn3rd]

What we need:
We need the names in Column I to show in Column F if the information in Column NL are either a C or an S (only these two letters). If neither letter is in the column we just need it to be blank like it is now.

What is already done:
We have it working for C but we are having trouble getting two letters in there so decided to call in the experts for help.

[amy_d2]

Hi

so you want below formula in column NL , pls confirm

=IF(IF(INDEX(J4:NJ4,1,MATCH(NL$3,$J$3:$NJ$3,0))="","",INDEX(J4:NJ4,1,MATCH(NL$3,$J$3:$NJ$3,0)))="C",IF(INDEX(J4:NJ4,1,MATCH(NL$3,$J$3:$NJ$3,0))="","",INDEX(J4:NJ4,1,MATCH(NL$3,$J$3:$NJ$3,0))),IF(IF(INDEX(J4:NJ4,1,MATCH(NL$3,$J$3:$NJ$3,0))="","",INDEX(J4:NJ4,1,MATCH(NL$3,$J$3:$NJ$3,0)))="S",IF(INDEX(J4:NJ4,1,MATCH(NL$3,$J$3:$NJ$3,0))="","",INDEX(J4:NJ4,1,MATCH(NL$3,$J$3:$NJ$3,0))),""))

[cy83rn3rd]

Nope; still didn't populate the name if they had a C or S.

Really I just need to see if there is a way to get this to include "C" and "S": =INDEX(I5,MATCH("C",NL5,0),1)

[windy58]

Could you not just use an IF OR statement?
=IF(OR(NL5="C",NL5="S"),I5,"")

Windy

[cy83rn3rd]

That worked!