copying formula question

[DeeZi]

let's say I have

A B C D
1 2 4 4
2 5 2 6
3 4 7 2
4 2 6 3
5 3 9 8

Now I do =INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0)) and I want to continu
doing it for columns C and D, but having it correspond back to the
column. So for example, the max of B is 5 corresponding to 2 in the
column. Max is C corresponding to 5 in the A column. I have a whol
bunch of columns and I wanted to copy the formula above but it onl
does it with columns next to each other. How can I get it so that i
keeps referring back to the A column but reads other columns instead o
manually changing each one.

Thanks again

 

[Guest]

If I understand correctly you need to type

=INDEX($A$2:$A$6,MATCH(MAX(B2:B6),B2:B6,0))

then you can copy the formula down the list.

 

[Dave Peterson]

maybe...

=INDEX($A$2:$A$6,MATCH(MAX(B$2:B$6),B$2:B$6,0))

And drag across.