trying to write function to find data in last row in 1 column

[Guest]

I am trying to write a function to find the data in a column in a row of the
sheet that is increased by one row each time more data is entered.
For example


A B C D E
1 4 5 7 9 11
2 7 11 3 5 9
3
4
I want to be able to write a function that will tell me the value of E2 this
time and then have the same function tell me what the value of E3 will be
after it is entered.

This is probably easy but I cant figure it out
Thanks

 

[Sandy Mann]

One way:

=LOOKUP(999^99,E:E)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk