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

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

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

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

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

Hello,

=LOOKUP(2,1/NOT(ISBLANK(B1:B999)),A1:A999)

Regards,
Bernd