Help pulling row data from MAX-IF

[SneakyWhale]

I have data that is split into cycles, each cycle has 8-10 rows. I have used a MAX-IF formula to pull the highest "Value 1" for each cycle
i.e.
=MAX(IF('Cycle'=1,'Value 1'))
=MAX(IF('Cycle'=2,'Value 1'))
=MAX(IF('Cycle'=3,'Value 1'))

However I would also like to show the data for 'Value 2' & 'Value 3' in the row where each MAX value was found, how can this be done?

Example
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Cycle[/TD]
[TD="align: center"]Value 1[/TD]
[TD="align: center"]Value 2[/TD]
[TD="align: center"]Value 3[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]a[/TD]
[TD="align: center"]y[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]d[/TD]
[TD="align: center"]z[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]b[/TD]
[TD="align: center"]x[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]b[/TD]
[TD="align: center"]w[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]a[/TD]
[TD="align: center"]x[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]c[/TD]
[TD="align: center"]y[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]f[/TD]
[TD="align: center"]z[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]c[/TD]
[TD="align: center"]w[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]a[/TD]
[TD="align: center"]w[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Try (untested)

=INDEX('Value 2',MATCH(MAX(IF('Cycle'=1,'Value 1'),Cycle,1,0),1)