I had completely forgotten that that formula did both.
Thanks for reminding me Gord!

--

Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
For anything, text or numeric, use this one.

'=LOOKUP(2,1/(A1:A65535<""),A1:A65535)


Gord Dibben MS Excel MVP

On Wed, 16 Jan 2008 10:08:36 -0000, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:

Hi
what is the 9.999999E+307?

It is just a large number (the largest that can be entered into Excel) or
one that would be unlikely to be found on your sheet.
For most purposes 99^99 is large enough, and many people use this in their
formulae instead. It is easier to type and to remember<bg
So, =LOOKUP(99^99,H:H)
will find the last numeric value in column H

If it is Text that you are looking for, then
=LOOKUP(REPT("Z",255)H:H)
will find the last test item.

REPT("Z",255) is a string of 255 Z's, i.e. something that is unlikely to
be
found in your spreadsheet.