refer to cell based on value

Try this if you don't have a column header

Formula:

=INDEX(C:C,COUNT(C:C),1)

or try this if you do have a column header

Formula:

=INDEX(C:C,COUNT(C:C)+1,1)

If you're using a version of excel older than 2007, you need to have start and stop values in the ranges