Lookup a date in a range of dates and return the Period in which the date belongs

I have a worksheet (DETAIL) where I enter the actual date an event occurred (Column B). Column A is designated as the Period (or Month) in which the event occured. Since our schedule is not an exact calendar month basis, I have set up a chart on a separate worksheet (LOOKUPS).
The chart has 4 columns:

Column A = Month (Jan-Dec)
Column B = Period (1-12)
Column C = Beginning Date
Column D = Ending Date

I want to create a formula on the DETAIL worksheet that will look up the Date in Column B and return with the Period from the chart in which that date falls.

I've tried if/or function but can't seem to get it to work.

Thanks for your help.

Hi,

In the DETAIL sheet A2 (period) where the entered date is in B2 try:

=SUMIFS(LOOKUPS!$B$2:$B$13,LOOKUPS!$C$2:$C$13,"<="&B2,LOOKUPS!$D$2:$D$13,">="&B2)

This will return the period number. Format the cell as mmmm and it will display the month name instead of period number.

HTH
Steve

Worked like a charm! Thanks!