Require a function to return a last non zero value in a column

[projectatpel]

<tbody>
[TD="colspan: 8"]Formula using LOOKUP function is not working for values generated from calculations in a column. I need to find the last non zero value.
I have used the formula
=LOOKUP(9.99E+307,1/(C9:C208<>0),C9:C208)
the column C has values that are calculated based on other cells in the sheet.
Attached at the following links is my excel file.Every thing is described in the file Urgent.....

http://www.filedropper.com/myrequirement

Wikisend: free file sharing service

[/TD]

</tbody>

 

[BrianMH]

My corporate firewall does not allow me to access your links. I can however say that the formula you posted works fine for me.

Are you sure you have auto calculation turned on?