you're welcome
i've seen there are also other options you can please to consider..
regards
--
*****
birds of the same feather flock together..



"Becks" wrote:

Cheers Driller, that worked a treat!

Becks

"driller" wrote:

Hi Beck
as shown on your sample, i assume that the columns A and B has data in
ascending order..
=LOOKUP(LOOKUP(2,1/(B1:B16<""),B1:B16),B1:B16,A1:A16)
u may get the date on column A that corrsponds to the last filled cell in
column B range.

--
*****
birds of the same feather flock together..



"Becks" wrote:

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