# harder than a simple IF statement

1. ## 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

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

2. ## Re: harder than a simple IF statement

Formula:
`Please Login or Register  to view this content.`

??

3. ## Re: harder than a simple IF statement

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.

4. ## Re: harder than a simple IF statement

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?

5. ## Re: harder than a simple IF statement

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.

6. ## Re: harder than a simple IF statement

rest of post deleted, OP has posted in CS, so I am closing this

There are currently 1 users browsing this thread. (0 members and 1 guests)