Hello everyone,

I have a calendar template on my Excel sheet that I want to populate with information from another sheet. This statement is working well:
=IF(Sheet1!B2=L17, Sheet1!E2, "")
But if I want to expand the criteria to say:
=IF(Sheet1!B2:B15=L17, Sheet1!E2:E15, "") So if any of the dates from B2:B15 match L17 (where the date is), it will return the text in box E2:E15.

Am I going about this wrong? (Obviously, because it isnt working!) I guess the better question is... is this something that I can do... If the date in the first sheet matches the date on the calendar, it populates a cell with the text information?

Thanks in advance!