sharon, try,

=LOOKUP(9.99999999999999E+307,E:E)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"sharon" wrote in message
...
I am trying to display the last entry in a column. I am using the
following
formula:

=LOOKUP(9.99999999999999E+307,E6:E4000)

My result shows up as zero if cell E4000 has nothing in it.

I am looking for a formula the looks at the entire E column and displays
the
value of the last cell with a number in it.