That worked thank you very much.


"Peo Sjoblom" wrote in message
...
If indeed you have a zero in the last cell it will return that, try this
instead

=LOOKUP(2,1/(F1:F53<0),F1:F53)


--
Regards,

Peo Sjoblom



"Ed Davis" wrote in message
...
I just realized that the formula = 0 unless something is in another cell.
Is there a way to just look for a number other than 0?





"Ed Davis" wrote in message
...
There are numbers between in cells f11 through f17.

When I change the lookup to f1-f17 I do get the number I am looking for
that is in row 17. But leaving the lookup as it is shows me nothing.
Remember there are formula's in almost every other row.


"Peo Sjoblom" wrote in message
...
That's impossible, it will return either #N/A or the last numerical
value (if there are no numbers)

--
Regards,

Peo Sjoblom


"Ed Davis" wrote in message
...
The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another
column so it is a formula.

I want to use the last number in that F column. It may be in any row
from 1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis