The INDEX/MATCH combination can also return an entire row
Say your range is A1:C300
Select a cell where you want your max value say D1
In D1 enter
Quote:
|
=INDEX($A$1:$C$300,match(max($A$1:$A$300),$A$1:$A$ 300,0),)
|
( THE COMMA BEFORE THE LAST PARENTHESIS IS ESSENTIAL !)
The cell returns a VALUE error
Pull it to the right to cover 3 cells ( all now contain the error)
Go to the formula bar and commit your formula with Ctrl+Shift+Enter
Now all values from the same row including your max value are neatly in place
(the same kind of reasoning can be applied to summing (or whatever) an entire row (or column with the comma before the INDEX part) in a table)