drag down formula that finds maximum in a column y and corresponding x in an other column

[dimitris]

Hello!
I have in the cells I4:I23 the variable y, and in the B4:B23 the variable x. I want to put in the cell L4 the maximum value of the I4:I23 and in the cell M4 the variable x that corresponds to that maximum(so if my maximum value was at cell I6 I want to appear in the cell M4 the value of B6). Then I want to drag the formula down so that in the cell L5 appears the maximum of the I27:I46 and at the cell M5 the variable x that corresponds to that maximum taken from the cells B27:B46. And so on (I want to drag it down for more maximums and corresponding x's)
Thank you

 

[vogel997]

	Try this..
L4	=LARGE(OFFSET($B$4,23*(ROW(A1)-1),,20),1)
M4	=INDEX(OFFSET(I$4,23*(ROW(A1)-1),,20),MATCH(L4,OFFSET(B$4,23*(ROW(A1)-1),,20),0))

<colgroup><col><col></colgroup><tbody>
</tbody>