If you are only interested numbers and wishing to ignore text values, I think this is your shortest formula to return the last non-zero value.

=INDEX(LOOKUP(2, 1/A:A, A:A))

If you have non-negative values, then it can be even shorter.

=LOOKUP(99^9,A:A)