This formula will help you in finding out the value in the last cell of a column. 

=LOOKUP(2,1/(ISNUMBER
(C1:C100)) ,C1:C100)