If your table had headers and occupied A1:C4 as in:

number date contract
10000 1/1/2008 contract a
30000 1/1/2009 contract b
30000 1/1/2010 contract c

And your criteria had headers and occupied A7:B8 as in:

number date
30000 1/1/2009

Then you could use DGET as in:

=DGET(A1:C4,"contract",A7:B8)

....to get whatever contract you want from the table.

HTHs.