Hi!

Try this:

=LOOKUP(100^10,A1:Z1)

Biff

"sadman49" wrote in message
...
I'm trying to writing a simple Formula which will only read from a cell
which
a last input was made.
Let's start from A1 thou to Z1, I have entered 237 in A1, 345 in B1, 453
in
C1 and so on, i'm up to cell J1 and have entered 123, I just want the last
input to show, how?
Hop you all can help