I mean this won't work in xl2003 and befo

=LOOKUP(2,1/(C:C=MAX(C:C)),A:A)

But this will work:

=LOOKUP(2,1/(C2:C65536=MAX(C2:C65536)),A2:A65536)

wrote:

On Oct 11, 6:09 pm, Dave Peterson wrote:
=LOOKUP(2,1/(C1:C99=MAX(C1:C99)),A1:A11)

Cute! Thanks.

Adjust the range to match, but don't use the whole column
(unless you're using xl2007).

By "whole column", I presume you mean a range ending with row 65536.
If not, please elaborate.

--

Dave Peterson