Based on your question I'm assuming only numbers will involved, no TEXT in
the range?

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

Will return the last value that is not a zero from row 1, A1:IV1.

Biff

"Ken Hudson" wrote in message
...
Hi,
I'm looking for a formula that will reutrn the last non-zero value in a
row.
TIA.
--
Ken Hudson