Try

=INDEX(7:7,LARGE(IF((D7:X70)*(D7:X70),COLUMN(D7: X7)),2))

Which is an array so commit with Ctrl+Shift+Enter NOT just enter

Mike

"Anto111" wrote:

Hi guys,

I need to return the second to last value (providing it is greater than
zero) from a data range. I already have a formula to return the value in the
last cell, this being:

=IFERROR(LOOKUP(2,1/($D7:$X70),$D7:$X7),"-")

I may be missing an obvious way to manipulate the above formula but would
appreciate any help.

Many thanks in advance,

Kind regards,

Ant