Try this:

=INDEX(A:A,MATCH(MAX(K:K),K:K,0))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"harvey1649" wrote in message
...
I want to look up the largest number in coloum K and return the value in
Coloum A that is in the same row that the largest number in Coloum K is.