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

Cycle	Value 1	Value 2	Value 3
1	5	a	y
1	5	d	z
1	6	b	x
2	11	b	w
2	3	a	x
2	5	c	y
2	8	f	z
3	7	c	w
3	9	a	w

<tbody>
</tbody>

 

[Special-K99]

Try (untested)

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