Copy last input in table

Excel pro!

I need your help. I have one column, column "A". In "A" I have a table from "A2" to "A13". I want the last value I put in this table, to be visible in cell "A16". In the table below, I call this cell for my "Current profit".

This is what I am looking for:

	A
1	Profit
2	2 300 EUR
3	2 100 EUR
4	2 600 EUR
5
...	...
16	Current profit: 2 600 EUR

• If I write "1 800 EUR" in cell "A5", I want this value to be displayed in "A16".

• If I delete the values in cell "A5" and "A4", I want the value in "A3" to be displayed ("2 100 EUR").

Hopefully this explanation is sufficient for describing what I want to achieve. Thank you for all help you can provide!

Try

=LOOKUP("zzzzzzzz",$A$1:$A$15,$A$1:$A$15)

or

="Current Profit: " &LOOKUP("zzzzzzzz",$A$1:$A$15,$A$1:$A$15)

Thank you so much! That worked!