HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right.

[Felix Raven]

Dear Excel Guru Community!

I thougth I'm good with formulas, but there is one thing I cannot solve.
Let's say, in row 7 I want to find the minimum value, and I want to get that value from row 8 which is in the column of the minimum value of the row 7.
Seems a piece of cake, let's try MIN, and then HLOOKUP or LOOKUP or MATCH.
The problem is, all three latter gives wrong result.
Please download the sheet from here with some more explanations:
https://www.dropbox.com/s/j2grmj0w2an4a4o/finding a value.xlsx?dl=0
Please help me to find the solution!
I am so disappointed, this thing cannot be impossible to do, but it seems it is...

Thanks & best regards,
Felix

 

[Felix Raven]

I've got it right:
=INDEX($B$8:$I$8;MATCH(MIN($B7:$I7);$B7:$I7,0))
Problem solved!