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

[projectatpel]

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

<tbody>
</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?