Simple Last number lookup questiion

HI
I tried to find a similar example in the forum but I was not able to find my example problem. I need to have cell at the end of a column of numbers that will pick the last available data input. There will be times when the cells within the column will not have a data point and there will be times when the data is not available since the data points are entered through the day. I need to know that last valid data point.If their is a skip in the data, would it be possible to say "n/a" ? I have attached a sample work sheet.
Thanks for you help in this matter.
Ted

Not sure what is your end result.

If you are looking to return the last value in C9:C33 where B9:B33<>0 AND C9:C33<>0, here is the one way,

=IFERROR(LOOKUP(2,1/B9:B33/C9:C33,C9:C33),"N/A")

will give you 13

See Attached WorkBook

Is that what you want?

If it is column C you need to find the last entry, then just change the "D" in the code to "C".