Find max value

Martin_H

New Member
Joined
Aug 26, 2020
Messages
26
Office Version
  1. 2016
Platform
  1. Windows
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.

Untitled.jpg
 

Attachments

  • 1598462894227.png
    1598462894227.png
    59.9 KB · Views: 0

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,413
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
In A1: =MAX(INDEX($D$8:$M$19,MATCH($N$5,$D$8:$D$19,0),0))
 

Watch MrExcel Video

Forum statistics

Threads
1,127,422
Messages
5,624,701
Members
416,042
Latest member
Oden

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top