Try this

=LOOKUP(2,1/(A1:A20<0),A1:A20)

Mike

"Mats Samson" wrote:

Is it possible to retrieve the last value greater or less than 0 in a column
range when there are 0-values above the value I'd like to find? There are no
blanks in the range, either 0 or greater or less than zero