harder than a simple IF statement

I am trying to work out the following problem where:

Cell A1 = Date
Column B= Event Name
Column C= Start Date
Column D = End date
Cell E1 = answer

I am trying to write a formula without macros where the Date in cell A1 can be found within the range of column C and Column D and return the corresponding B (event name or names) in E1

A simple if statement below works for 1 cell in B, C & D but not when trying to search the entire column. When I try to do that I get a Value error

Thank you for your quick response. Unfortunately when I tried to use this formula it gave me an error with no help . I actually created a separate spreadsheet and did it exactly the way it was noted with no luck. Any help would be appreciated.

I also tried this which returned one result....

=INDEX(B2:B100,MATCH(1,INDEX((C2:C100<=A1)*(D2:D100>=A1),),FALSE))

The challenge is that Date in A1 may be found in more than one cell in row C or D so I need to be able to return multiple results. Any thoughts?

Please see thread below and advise if you can help. I am hoping this is now the service I paid for. I am unsure how this works.