=INDEX(1:1,MIN(IF(2:2<0,COLUMN(2:2))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jiang" wrote in message
...
I intend to locate a cell that records the first value which is not zero
(an
example is given below). The Index and Match functions don't seem to work.
Any solutions would be highly appreciated.

01/06/05 01/12/05 01/06/06 01/12/06 01/06/07
0% 0% 5% 40% 0%

I intend to capture the cell with date "01/06/06", which shows 5% - i.e.
the
first cell from the second row which is not zero.