Combined IF Statement

Refer to attached spreadsheet. In B1 is the day of the month and I want to match it to the number in the grid and return a Y or N in the Occupied column if a code is in that row. So on the attached spreadsheet, all would be Y except for Row 15.