vlookup formula for past dates

[exceluser9]

Hi There

I have a data like this in 2 sheets

	SHEET 1					SHEET 2
COLUMN C	COLUMN D	COLUMN E			COLUMN C	COLUMN F	COLUMN I
YEAR	AMOUNT	DATE			YEAR	AMOUNT	DATE
2005					2005	500
					2005	600	10/07/2015
					2005	700	21/09/2015

<tbody>
</tbody><colgroup><col><col><col><col span="2"><col><col><col></colgroup>

In sheet 1 if i give any date before 10/7/2015 i should get the amount 500 is it possible?

For example like this

COLUMN C	COLUMN D	COLUMN E
YEAR	AMOUNT	DATE
2005	500	06/07/2015

<tbody>
</tbody><colgroup><col><col><col></colgroup>

Thank you in Advance

 

[gaz_chops]

Then try

=SUMIFS(Sheet2!$F$2:$F$100,Sheet2!$C$2:$C$100,C2,Sheet2!$I$2:$I$100,"")