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

Feb 27, 2015
Reaction score
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,


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question