Lookup column header of minimum value

[markdwalls]

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

 

[kvsrinivasamurthy]

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]

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?