What value does

=LOOKUP(2,1/(E6:E4000<""),E6:E4000)

in contrast to

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

which appears to return a real 0?

sharon wrote:
Worked like a charm!!! Thanks!!!!!

"Nobody" wrote:

try this:
=LOOKUP(2,1/(E6:E4000<""),E6:E4000)

------------------
mama no teeth

"sharon" wrote:

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.