Please Help me. Searching for a certain text in a column, and entering yes/no in a certain cell

[djbadabing1]

Im am looking to create a schedule template where:
Row #1 has Monday - Sunday
Column A has a list of employee names

The employees work at certain stations 1-15 that will be placed under certain days of the week in their row.

I want a reference column to the right of this table that lists all stations in numerical order 1-15, and another column to the right of that column that has a header of "check". When station number 4 is entered in a column for monday, I want YES to appear in the check column next to station 4. And the same for all other stations. It will be a way for me to easily verify that all stations are scheduled for that day. I need to have a verification section for each day of the week. Im not great with formulas, I've tried IF, VLOOKUP, SEARCH, and I'm having no luck with my basic knowledge of excel. That is why I came here. I would appreciate any help with this formula, as I have too many hours wasted with no end result. Thank you for your time.

 

[djbadabing1]

Okay, I see (the posted layout was not all that clear to me). See if this formula in K2 copied across and down does what you want...

=IF(COUNTIF(B:B,$J2&"*"),"YES","")

It works, but YES is entered for multiple stations. When a "1" duplicated in the field. Example: If I enter #12 on wednesday for Brad, #1 & #12 will have a YES input.

 

[Rick Rothstein]

It works, but YES is entered for multiple stations. When a "1" duplicated in the field. Example: If I enter #12 on wednesday for Brad, #1 & #12 will have a YES input.

Sorry, I forgot the slash...

=IF(COUNTIF(B:B,$J2&"/*"),"YES","")

 

[cyrilbrd]

You could have used as well =IF(ISNUMBER(MATCH($J2,B$2:B$6,0)),"YES","")