Check Column A for a match to text, Check Column B for a match to a date & put X in Cell

[cat3rn]

I am trying to work on a 5 day a week 6 - 2hr slot daily schedule for the month of October.

On one sheet I have the time of slot in Column A (4 thru 33) and on that same sheet I have a popup calendar that inserts the day of the event in Column B (4 thru 33).

On the second sheet I have a Monday thru Friday list with 6 time slots for each day for each week in October.

What I want to do is when a time is chosen in Column A and a date is chosen in column B, I want that date and time checked and an X put on the second sheet to indicate that the time slot for that day has been booked.

Any help would be appreciated.

How do I upload a file for all to look at?

I am using Windows 8.1 64bit and Excel 2010.

 

[cat3rn]

I have tried

=IF(AND(List!$A$4:$A$27="9am",List!$B$4:$B$27=41913),"X","")

=IF(AND(List!$A$4:$A$27=H4,List!$B$4:$B$27=$J$5),"X","") ****WITH A LIST TO CHOSE FROM FOR H4****

=IF(AND(ISNUMBER(MATCH(A4,List!$A$4:$A$33,ISNUMBER(MATCH(A4,List!$A$4:$A$33))))),"X","")

All give me some #VALUE errors