Max date vlookup based on other criteria

[CEnd99]

Hi,
I am trying to do a vlookup of the square footage of a unit based on the most recent date it was updated. I have gotten to where I can get the most recent square footage but I can't figure out how to add the condition in so that I don't have to manually create the unit ranges
Here is the formula I am using for the most recent date: =VLOOKUP(MAX(E3:E8),E3:F8,2) and here is a sample of the data I am using. I want to be able to tie the code and it find the range for me.

Code Property Unit SF_Type Asof_Date Square_Footage
182-100 182 100 Rent-Rented SF 01/08/2003 4263
182-200 182 200 Rent-Rented SF 01/04/1999 3160
182-200 182 200 Rent-Rented SF 01/01/2001 3545
182-200 182 200 Rent-Rented SF 01/06/2001 1628
182-200 182 200 Rent-Rented SF 01/05/2009 1778
182-200 182 200 Rent-Rented SF 01/04/2013 2000
182-200 182 200 Rent-Rented SF 01/06/2013 1706
182-250 182 250 Rent-Rented SF 01/04/2013 1150
182-250 182 250 Rent-Rented SF 01/06/2013 1129
182-300 182 300 Rent-Rented SF 01/10/1998 2700
182-300 182 300 Rent-Rented SF 01/10/2004 2731
201-0100 201 0100 Rent-Rented SF 27/03/2008 1561
201-0300 201 0300 Rent-Rented SF 01/07/2008 10966
201-0560 201 0560 Rent-Rented SF 01/08/2004 2051


Thanks

 

[MARZIOTULLIO]

Hi may be

[TABLE="width: 397"]
<colgroup><col><col><col span="5"></colgroup><tbody>[TR]
[TD][TABLE="width: 453"]
<colgroup><col><col><col span="6"></colgroup><tbody>[TR]
[TD][TABLE="width: 447"]
<colgroup><col><col><col span="2"><col><col span="2"></colgroup><tbody>[TR]
[TD]code[/TD]
[TD]date[/TD]
[TD]square[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]1/12/2015[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="colspan: 3"]=SUMIF(G2:G5,MAX(G2:G5),H2:H5)[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]4/12/2015[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD="align: right"]3/22/1999[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]for same date sum[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]5/12/2004[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]