Ruff,

Just amend Vezerid's formula to

=INDEX(A1:A12,MAX(ROW(1:12)*--(B1:B12<0)))

or try mine

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ruff" wrote in message
...
hi vezerid,

Thanks for your reply, maybe not detail enough I wrote the mail before.
Actually I want the cell A13 automatically detect the B1:B12, each month I
the value in the B column, A13 will detect if the cell not equal to 0,
then
it show the A column text. That mean last step B7 get the value it show A7
value in A13, if I carry on to enter the value in B8, then A13 show the A8
value.

Thank you so much.
Ruff

"vezerid" ¼¶¼g©ó¶l¥ó·s»D
.com...
Ruff,
I understand that the months will be filled in chronological order.
Hence you want the last month entered.
The formula I am suggesting for A13 is an array formula, i.e. you need
to enter it with Shift+Ctrl+Enter
=INDEX(B1:B12,MAX(ROW(1:12)*--(B1:B12<0)))

HTH
Kostis V