Try this:

=LOOKUP(1E100,D4:D100,B4:B100)


--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
Excel2003 ...

Range B4:B100 ... Contains random non-repeating "Text" numbers sorted in
"Asc" order.
Range D4:D100 ... Contains empty cells & random Dates (mm/dd/yy)

Need formula in Cell D3 to return Col B value found against "last" date
(not
latest date)

ie:

Col B ... Col D

10 .... 04/22/08
20 .... 06/25/08
35 ....
45 ....
50 .... 05/01/08 ... (need 50 to be returned)
62 ....
Etc

Thanks ... Kha