Find max value

[Martin_H]

Hi everyone,

I am trying to build a formula, but no luck.

In the yellow cell (N5) I have a drop-down list of months that I can choose from. Currently, month "feb" is chosen.

Now, I would like to get max value from the table below, from row coresponding to month "feb", so in this case from range E9:M9. I would like to display this MAX number in cell A1.

If I change the month in yellow cell to lets say "jan", I would like to get max value from E8:M8, also in cell A1.

I hope it is clear.

Thanks alot for help.

 

[JoeMo]

In A1: =MAX(INDEX($D$8:$M$19,MATCH($N$5,$D$8:$D$19,0),0))

 

[Martin_H]

Beautiful, thank you very much JoeMo!

 

[JoeMo]

Beautiful, thank you very much JoeMo!

You are welcome - thanks for the reply.