Actually, that is what I meant, I don't know why I copied the <0 (slap for
me too <g)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ron Rosenfeld" wrote in message
...
On Sat, 14 Oct 2006 12:52:21 +0100, "Bob Phillips"
wrote:

=LOOKUP(2,1/(A1:A1000<0),A1:A1000)

works for me

Yes, of course. <sound of slap to forehead

Actually,

=LOOKUP(2,1/(A1:A1000),A1:A1000)

should work also, for non-zero numeric values.


--ron