VLook Up with Conditions

[Merlin54k]

Column C From Column with dates in Cells C2 through C6 going from 3/31/2016 to 3/31/20 (in cell C6)
Column D To Column with dates in Cells D2 through D6 going from 4/1/2017 to 4/1/2021 (in cell D6)
Column E Years listed from 2016 through 2020 in cells E2 through E6.

Cell G2 lists 12/18/2016, what formula can I use in cell H2 to retrieve the Year greater than column C but less than the date in column D?

[modytrane]

use this in H2 and drag it down:

=SUMPRODUCT((E$2:E$6),--(G2>C$2:C$6),--(G2<D$2:D$6))