Formula help!

[Guest]

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

 

[Don Guillett]

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

 

[Guest]

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.

 

[Guest]

Cheers Driller, that worked a treat!

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.

 

[Bernd]

Hello,

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

Regards,
Bernd

 

[Guest]

you're welcome
i've seen there are also other options you can please to consider..
regards