HLOOKUP LOOKUP & MATCH gives a wrong answer or error message. It doesn't seem right.

FelixRaven

New member
Joined
Feb 26, 2015
Messages
2
Reaction score
0
Points
0
HLOOKUP LOOKUP & MATCH gives a wrong answer or error message. It doesn't seem right.

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.
I attached the sheet with some more explanations.
Please help me to find the solution!
I am so disappointed, this thing cannot be impossible to do, but it seems it is...

Best regards,
Felix
 

Attachments

  • finding a value.xlsx
    12.1 KB · Views: 21
Last edited:
Try this

=INDEX($B$8:$I$8,MATCH(MIN($B7:$I7),$B7:$I7,0))
 
Back
Top