Finding Period within date range

[ronie85]

Hi, I require a formula in C18 (Red) That uses the date in C18 (Green), searches it within the date ranges of Columns D and E, and produces the result of Column G depending on which Row that date falls on.

Thanks in advance.

 

[Special-K99]

E3 and D4 years are wrong - unless we can travel backwards in time

Try
=VLOOKUP(C18,D3:G14,4,1)

 

[ronie85]

That worked thanks a lot