last number above zero in long column

I have a long column of cells. Some have numbers, some are 0.

I need to detect the last number in this column. It will be among the last 20 rows.

I've tried something like this without success:

=LOOKUP(1000000000000,AT:AT)

. (the result is blank).

Any suggestions?

Thanks.