Need help managing a list of data........

I have a very large list of data that I am manipulating.

My question is this ----

If I use the MAX command to get the highest number in the list, how can I can get the corresponding name, etc. that goes with it?

If your names are in A, and values in B,

=INDEX(A:B,MATCH(MAX(B:B),B:B,0),1)

will give the name on the same row as the maximum value in B

hth

Dave

Originally Posted by sweep

If your names are in A, and values in B,

=INDEX(A:B,MATCH(MAX(B:B),B:B,0),1)

will give the name on the same row as the maximum value in B

hth

Dave

Thanks, I'll try that. I have heard of the index command but have never used it and wasn't sure how it works.........