Max Index Match formula

[chipps24]

Hi, having a few issues combing the Max, Index and Match formulas. Any help is greatly appreciated.

In the attached very simple SS, I am trying to lookup the Max value in Column B, given a certain series in Row 1.

For example, the 6th data point in Row 1, should correspond to the largest value within B1:B6. This is 20, not 15 like I have.

The answers I'm looking for are in Row 3.

Thanks very much in advance.

[JohnTopley]

Try

=MAX(D4,MAX(INDEX($B$1:$B$10,MATCH(E$1,$E$1:E1,0))))

[José Augusto]

Hi
Try this in E2 and copy to right

Please Login or Register  to view this content.

[Jonmo1]

Try

=MAX($B$1:INDEX($B$1:$B$10,MATCH(E1,$E$1:E1,0)))


Though I don't think the Match is required here, so try
=MAX($B$1:INDEX($B$1:$B$10,E$1))

[chipps24]

Thanks all for your help, much appreciated!

[Jonmo1]

You're welcome.