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
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
Last edited: