Assuming that column C contains *only* numbers:

=IF(COUNTIF(C:C,"0"),LOOKUP(2,1/(C2:C200),C2:C20),"")


--
Biff
Microsoft Excel MVP


"Paperback Writer" wrote in
message ...
These work!

BUT! Now, I need a very similar solution. Let's say that Column C has
zeroes in it. How to return the last value that isn't a zero? In the
example below, it will show 190. The solutions posted thus far would all
show 0. -- Thanks!!!!

Column B Column C
02/01/2008 192
02/02/2008 191
02/03/2008 190
02/04/2008 0
02/05/2008 0