Return values in a row from a value in a column - Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have four columns from which I have a formula pulling the maximum value from thousands of rows. I want to find a way to have Excel give me the corresponding values in the row where the maximum value was found, but from a different set of columns.
I tried VLOOKUP but it requires you to know the column from where you want the reference value to come from, and it has to be the first column.
Please help, I cannot find any other function which will do what I want.

Thanks
 
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX($A$1:$A$10000,MIN(IF($A$1:$D$1000=MAX($A$1:4D$1000),ROW($A$1:$D$
1000)))

and
=INDEX($B$1:$B$10000,MIN(IF($A$1:$D$1000=MAX($A$1:4D$1000),ROW($A$1:$D$
1000)))
....
 
Voila, j'ai un tableau de + de 1000 clients, avec leurs coordonnees sous excel. Je voudrais que quand je rentre le nom d'un client ds une cellule specifique, il m'enmene directement sur la ligne du client. Tu connais la fonction?
 
Hi
sorry, make this:
=INDEX($A$1:$A$1000,MIN(IF($A$1:$D$1000=MAX($A$1:$D$1000),ROW($A$1:$D$
1000)))
 
Back
Top