On Sat, 15 Mar 2008 08:29:02 -0700, Teethless mama
wrote:

Your formula returns #NUM! error prior to XL-2007
Last entry in column A:
=LOOKUP(2,1/(LEN(A:A)0),A:A)

should be:
=LOOKUP(2,1/(LEN(A1:A65535)0),A:A)

I just switched to 2007. I guess "compatibility mode" in 2007 doesn't take
that into account. Thanks for the correction.
--ron