Hi David

=INDEX($A$1:$B$1000,SMALL(IF($B$1:$B$1000<0,ROW($ B$1:$B$1000),""),1),1)

entered using control & shift & enter not just enter

Cheers
JulieD

"DAVID" wrote in message
...
I have two columns A and B. Column A contains ascending numbers from 1 to
100, column B contains arbitrary values (not in ascending order). What is
the
function that looks for the first nonzero value in column B (going from
the
frist to the last row) and returns the value of column A of the same row?