Trying to create an IF statement that reads the logical_test from a range

Hello!

I am trying to make an automated day planner on excel. Here is how I WANT it to work:

1) I have a list of activities where I input the Title (B), Date (D), and Time (C).
2) I have made a schedule with the days of the week across the top, and the time running vertically down the side.

Currently, this formula: =IF(AND($D33=C$1,$E33=$A24,$F33=$H$33),$B33,"free") is working, but will only allow me to enter one value for Logical1 ($D33=C$1), Logical2 ($E33=$A24), and Logical3 ($F33=$H$33).

I tried doing: =IF(AND($D33:D47=C$1,$E33:E47=$A24,$F33:E47=$H$33),$B33:B47,"free") , but it shows up as #VALUE!
I also tried: =VLOOKUP(AND(D1,A24,H33),B33:F47,1,FALSE) but it shows up as #N/A although the conditions would have been met


HELLLPPP!!