One way where c has dates and b has strings
=INDEX(C3:C10,MATCH("zzzzzzzzz",D3:D10))

--
Don Guillett
SalesAid Software

"Becks" wrote in message
...
Hi - I have two columns as below:
A B
01/03/07 B1234
01/04/07 B1235
01/05/07 B1236
01/06/07

I need a formula that will find the last entry in column B and return the
date on the same row from column A, is this possible?

Thanks

Becks