I am trying to do a lookup to find data that falls between a range of dates. For example:

Sheet1
name | reference | shipped date
Harry | BA1001 | 10/06/09
Harry | BA1034 | 20/06/09
George| BA1065 | 20/06/09
Harry | BA1235 | 14/07/09
Rob | BA1345 | 10/06/09
Harry | BA1564 | 23/10/09

Sheet2
name | reference | paid date
Harry | ????????? | 12/7/09

The ? is the data that i am looking for. The closest date after the 12/7/09 is the 14/07/09 and therefore should come back with:

Sheet2
name | reference | paid date
Harry | BA1235 | 12/7/09

Note that the look up value in this case is "Harry" with the date closest to "12/7/09" to return the value X. This is very similar to vlookup except that vlookup but with the "between dates" part added.

How do I do this?