Lookup column header of minimum value

markdwalls

New Member
Joined
May 15, 2018
Messages
15
Hi All,

I'm trying to find a way for my sheet to return the column header of where a minimum value is found in a table that also contains blanks.
Below is a screenshot of what i currently have.
I already have the minimum value from using a simple =MIN(X) formula as you can see in cell B6. In cell A7 i would like it to display the heading of that minimum value. In this case the minimum value is 1000 and the heading is "Bottom (mm)". So i basically need a formula to return that "Bottom (mm)".

Thanks in advance

1601989139637.png
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

kvsrinivasamurthy

Well-known Member
Joined
Nov 6, 2013
Messages
674
If Data range is C10:L30. Change if necessary.

=IFERROR(INDEX($C$9:$L$9,SUMPRODUCT((C10:L30=$B$6)*COLUMN($C$9:$L$9))-COLUMN($C$9)+1),"")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,691
Office Version
  1. 365
Platform
  1. Windows
What version of Excel are you using?
Please update your account details, as it affects which functions you can use.

Also can the minimum number occur more than once in your data?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,919
Messages
5,627,624
Members
416,257
Latest member
salomon

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