Try this:

=LOOKUP(2,1/(L1:L65535<""),L:L)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BAKERSMAN" wrote in message
...
This is pulling the first alpha numeric value, is there a way to pull that
last value.

"Max" wrote:

Array-enter in say M1:
=INDEX(L1:L65535,MAX((L1:L65535<"")*ROW(1:65535)) )
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BAKERSMAN" wrote:
Ok how do you lookup the last alpha numeric value in a column L ?