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!!

It would be easier to help if you could attach a copy of your workbook. Remember to remove/replace any sensitive data before uploading.

Hard to get it without a worksheet, anyway try:

=IFERROR(LOOKUP(2,1/(($D33:D47=C$1)*($E33:E47=$A24)*($F33:E47=$H$33)),$B33:B47),"free")

Hi and welcome to the forum

hard to say without seeing any data to test on, but try entering your formula...
=IF(AND($D33:D47=C$1,$E33:E47=$A24,$F33:E47=$H$33),$B33:B47,"free")

as an ARRAY formula...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

@Fdibbins, what to do with values found from range B33:B47? Maybe OP want to SUM them or pull them out rather than to establish a range.

I have no idea lol, but by using ranges like that, it seemed it might work as an ARRAY...
=IF(AND($D33:D47=C$1,$E33:E47=$A24,$F33:E47=$H$33),$B33:B47,"free")