Smallest number - fill in this field name

[druchex]

Hello,

I am not a power excel user and while I'm sure this is easier than I'm making it, I'm struggling with the formula I should use. I have used a geocoding software to tell me how far customer addresses are from each of my companies offices. I need a formula that will look at C2:G2 and then returns the name from sells C1:G1 for the smallest number. For example, for row 1, cell E2 is the smallest number so I'd like my formula to fill E1 to H2. For row 4, the smallest number is cell C4, so H4 should fill in C1.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Mad[/TD]
[TD]Wauk[/TD]
[TD]Appl[/TD]
[TD]RM[/TD]
[TD]Bloom[/TD]
[TD]Closest Office[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]85[/TD]
[TD].72[/TD]
[TD]155.26[/TD]
[TD]248[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]128[/TD]
[TD]119[/TD]
[TD]34[/TD]
[TD]189[/TD]
[TD]234[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]78[/TD]
[TD]136[/TD]
[TD]175[/TD]
[TD]143[/TD]
[TD]208[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thank you!

 

[Jonmo1]

Try

=INDEX($C$1:$G$1,MATCH(MIN($C2:$G2),$C2:$G2,0))


Note, if there are blanks in the range, they will be considered 0 and will be chosen as the smallest value.

 

[druchex]

Perfect, thank you so much!

 

[Jonmo1]

You're welcome.