Hi Ratboy

Assuming those values in A1:B8 then you could use the following formula (it may not be a huge improvement on what you have though):

=LOOKUP(2,1/(B1:B8="One"),A1:A8)
Hope this helps!

Richard

EDIT: this also assumes that the dates are sorted ascending down column A...