Problem: Find last input value in a column

 

Solution: =INDIRECT("A" & (COUNTA(A:A)))

Functions:
INDIRECT(ref_text;[a1])
Returns the reference specified by a text string

COUNTA(value1;[value2];...)
Counts the number of cells in a range that are not empty