or
=INDEX(A:A,MATCH(99999999999,A:A)-1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dartanion" wrote in message
...
I am using the formula =LOOKUP(2,1/(1-isblank(b10:b65536)),b10:b65536) to
return the last entry in column b, and this works perfectly well, however,
I
need to also use the 2nd last entry, anyone any ideas