find date interval and lookup value

[voycron]

i have compile a table that would determine the value im looking for, please see below:
A || B || C || D || E || F
1 || Start Date ||End Date || Debit Month
2 || 19-Apr || 15-May || MonthA
3 || 17-May || 19-Jun || MonthB
4 || 21-Jun || 17-Jul || MonthC
5 || 19-Jul || 21-Aug || MonthD
6 || 23-Aug || 18-Sep || MonthE
7 || 20-Sep || 23-Oct || MonthF
8 || 25-Oct || 20-Nov || MonthG
9 || 22-Nov || 23-Dec || MonthH
10 || || || |||| 26-Aug || MonthE

In cell E10 i have entered a date e.g 26-Aug.
I would like to enter a lookup formula in F10 to return 'MonthE'

any date that i enter in e10, i would like for excel to determine with date interval it falls in the table and then return the value in Column C

The dates as well as the names/ids in column c may change, but the dates will never overlaps each other or start on the same date that the previous one ended on

The table can be in a transpose format or in any order, it does not matter.

Any help or ideas will be much appreciated
Thanks

 

[Jonmo1]

Welcome to the board...

Try this, provided the Begin Date of each interval is in column A, and the corresponding Debit Month is in column C

=LOOKUP(E10,A:C)