Multiple Criteria INDEX with dates and missing values

[rrbest]

I have the following table which has three columns, the first contains a date (that may be missing periods and/or have duplicate values), and ID, and a value corresponding to the date and value. Date + ID will produce a unique value. The user can select an "Entry Date" in this case, August 2011, which is not shown on the table of available dates. There is an output table which lists the unique IDs, and the most recent value as of the entry date (in this case, ABC shows the value for July 2011, DEF shows the value for June 2011). What formula could I use to produce these output values?

Date	ID	Value		Entry Date	Aug-11		Output
Jan-11	ABC	1					ID	Value
Feb-11	ABC	2					ABC	5
May-11	ABC	3					DEF	4
Jun-11	DEF	4
Jul-11	ABC	5
Sep-11	DEF	6
Sep-11	ABC	7

[rrbest]

I have resolved this problem with the following formula, feel free to comment if you have improvements:

{=INDEX($C$2:$C$8,MATCH(MAX(IF($B$2:$B$8=H4,IF($A$2:$A$8<=$F$1,$A$2:$A$8))),IF($B$2:$B$8=H4,$A$2:$A$8),0))}