Results 1 to 3 of 3

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files
    Last edited by FelixRaven; 2015-02-27 at 12:58 AM.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    Try this

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

  3. #3
    Dear Bob! Thanks a lot, it did the trick!
    Woohoo!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •