One way. Also, use less than 65536
=INDEX(A:A,LOOKUP(2,1/(1-ISBLANK(A10:A65536)),A10:A65536)-1,0)

--
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