Try...

=LOOKUP(9.99999999999999E+307,IF(A10:L100,A10:L10 ))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"cincode5" wrote:

Hi everyone.

I was wondering what function in Excel can be used to return the last value
in a range of cells.

Specifically - Row 10 has 12 cells in it that contain monthly forecast
values for Jan - Dec. I need the value of the 13th Cell M10 to contain the
last value in the row that is 0.

I'm sure this is embarrassingly simply, and any insight would be greatly
appreciated.

Regards...